Category Archives: Computing – general

Daily Download 30: Data Transfer, to and from VBA

Posted on 17/10/2012 by dougaj4

Today’s downloads cover procedures and functions for the transfer of data between VBA and the spreadsheet, and within VBA. Array resources provides a variety of resources and web links covering the transfer of data on the spreadsheet to VBA arrays. Download: http://www.interactiveds.com.au/software/getarray.zip … Continue reading →

Posted in Arrays, Computing - general, Excel, UDFs, VBA | Tagged , , , , , , | Leave a comment

Daily Download 29: Using VBA – linking to C

Posted on 16/10/2012 by dougaj4

The final few days of the daily download series will be dealing with the use of VBA, starting with linking to C (and C++).  This was covered in: Linking Excel to C Linking Excel to C – 2 Linking Excel … Continue reading →

Posted in Computing - general, Excel, Link to dll, UDFs, VBA | Tagged , , , , | Leave a comment

Daily Download 27: Miscellaneous

Posted on 15/10/2012 by dougaj4

Just some bits and pieces that don’t really fit in anywhere else today: Get your spreadsheet to talk to you at: Newton Excel Shakespeare Download: http://www.interactiveds.com.au/software/Text2Speech.xlsb Anniversaries gives you the tools to avoid missing significant anniversaries (and also to find the value … Continue reading →

Posted in Computing - general, Excel | Tagged , , , | Leave a comment

Daily Download 12: ImageMagick and Excel

Posted on 28/09/2012 by dougaj4

Today’s download provides a simple way of adding images to Excel from a list of file names, using the freeware program ImageMagick. See ImageMagick and Excel and ImageMagick – Update and add IrfanView link Download file:  http://www.interactiveds.com.au/software/PastePic.zip

Posted in Computing - general, Excel, VBA | Tagged , , , | 1 Comment

Newton Excel Shakespeare

Posted on 27/02/2012 by dougaj4

Another excellent link from Al Vachris: Bruce McPherson’s Site This site is all about how to free your Excel data from your desktop and take advantage of web capabilities such as Docs, Maps, Earth , Gadgets, Visualizations and a whole … Continue reading →

Posted in Computing - general, Excel, Javascript, VBA | Tagged , , , , , | 2 Comments