Category Archives: VBA

Silverfrost Personal Fortran

Posted on 24/11/2008 by dougaj4

Silverfrost Personal Fortran is a Fortran95 compiler that is free for personal use.  According to the suppliers: “With Silverfrost FTN95: Fortran for Windows you can create console based, conventional Windows® and Microsoft .NET applications. Silverfrost FTN95 is the only compiler that … Continue reading →

Posted in Computing - general, Excel, Fortran, Link to dll, Newton, VBA | Tagged , , , | 1 Comment

Finding Prime Numbers with Excel, and using Array Formulas

Posted on 18/11/2008 by dougaj4

Download Primes.zip. Several of the puzzles at Project Euler (see previous post) require the finding of prime numbers, for instance what is the 10,001th prime number?  Searching the Web for some ready made solutions I found this array formula at … Continue reading →

Posted in Arrays, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 28 Comments

Drawing in Excel 7 – Creating drawings from coordinates

Posted on 11/11/2008 by dougaj4

Previous Post, Drawing in Excel 6 The file PlotXYcontains routines to plot scale drawings in Excel from a list of XY coordinates of node points, node points for each shape, and formatting details for each shape type.  The plot is scaled … Continue reading →

Posted in Drawing, Excel, VBA | Tagged , , , | 25 Comments

A Question of Spelling

Posted on 01/11/2008 by dougaj4

The Excel VBA routine below will check the spelling of the text in the current selected cell, and return either TRUE or FALSE in the adjacent cell to the right: Sub SpellChecksub() Dim Checkword As String, Result As Boolean Checkword … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , | 15 Comments

ImageMagick – Update and add IrfanView link

Posted on 19/10/2008 by dougaj4

The picture indexing spreadsheet presented in the previous post has been updated: Comments can now be added adjacent to the file names, and these will be copied along with the Exif data The routine to copy the exif data to … Continue reading →

Posted in Drawing, Excel, VBA | Tagged , , , , , | 4 Comments