Tag Archives: UDF

Daily Download 31: Linking to Fortran

Posted on 18/10/2012 by dougaj4

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

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 26: Moving averages and prime numbers

Posted on 13/10/2012 by dougaj4

Today’s downloads are the last of the maths related functions: http://interactiveds.com.au/software/MovAv.zip provides a User Defined Function (UDF) to return the moving average of a set of data, and http://www.interactiveds.com.au/software/Primes.zip is a UDF to either generate a set of prime numbers between specified … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 1 Comment

Daily Download 25: Vector Functions

Posted on 12/10/2012 by dougaj4

Today’s download file provides a variety of vector arithmetic functions, which can be used either from other VBA routines, or on the spreadsheet as User Defined Functions. Download file: http://interactiveds.com.au/software/VectorFunc.xlsb In addition to Dot and Cross the spreadsheet contains the following … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | Leave a comment