Category Archives: Computing – general

GeodesiX

Another link from Alfred Vachris: GeodesiX is is an addin for Microsoft Excel which allows you to display maps, perform forward and reverse geocoding, compute distances (Great Circle, driving, bicycling and walking) and verify your results in Google Maps, all within … Continue reading

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

Installing dlls on 64 bit Windows

Several of the spreadsheets available here include routines linking to compiled code written in C#, C++ or Fortran, which require the installation and registration of dll files.  The procedures for doing this are significantly different on machines with 64 bit … Continue reading

Posted in Computing - general, Excel, Link to dll, VBA | Tagged , , , | 10 Comments

What is VBA good for? …

… is the name of a Stackoverflow thread that sends a steady trickle of visitors here (thanks to a link posted by Charles Williams of FastExcel).  On a similar theme, Smurf on Spreadsheets has a post entitled “What’s so good … Continue reading

Posted in Computing - general, Excel, VBA | Tagged , , , | 16 Comments

Daily Download 33: Miscellaneous

This is the last of the month and a bit of Daily Downloads, and consists of a bumper bundle of 20 spreadsheets with miscellaneous functions that didn’t fit in elsewhere: Repeating a set of data: for instance making three copies of … Continue reading

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

Daily Download 31: Linking to Fortran

Several routines linking to Fortran dll files, produced with the Silverfrost Fortran compiler, have been provided in previous daily downloads.  Today’s files are example routines, provided with posts covering the procedures to link Excel to Fortran code.  Note that these files … Continue reading

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