Category Archives: Excel

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

ImageMagick and Excel

Posted on 17/10/2008 by dougaj4

Back from my holidays, with a hard disk full of holiday snaps, and looking for a program to extract the image data saved on the camera, and add comments.  Not liking the offerings provided with the cameras, or any of … Continue reading →

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

Drawing in Excel 6 – getting shape properties

Posted on 17/09/2008 by dougaj4

Previous post One of the less than useful new “features” of Excel 2007 is that its macro recorder no longer records operations on shapes, which removes the easiest way to discover the exact names of shape properties, and how to manipulate … Continue reading →

Posted in Drawing, Excel, UDFs, VBA | Tagged , , , , | 5 Comments

Linking Excel to C – 3; Avoiding bottlenecks

Posted on 08/09/2008 by dougaj4

The previous post in this series included a C dll to solve cubic polynomial equations that could be called from VBA.  The performance of this routine is compared with a VBA routine using a similar algorithm in the sceenshot below (rows … Continue reading →

Posted in Arrays, Excel, Link to dll, UDFs, VBA | Tagged , , , | 2 Comments