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 versions of Windows. These procedures are not complicated, but they are not well documented, and the naming conventions used are confusing. The instructions given below are based on my own inexpert investigations; if anyone has any corrections, clarifications, or a better way of doing things, I’d be glad to hear from you.
All the compiled applications available here (so far) are compiled as 32 bit dlls. These should be copied to the Windows\SysWOW64 folder, not Windows\System32, so:
- 32 bit applications go in SysWOW64
- 64 bit applications go in System32
The applications written C++ or Fortran are then registered using the version of Regsvr32.exe in the SysWOW64 folder.
Applications written in C# use the COM (Component Object Model) and the .Net framework, and are installed using the Regasm application, as described here. In this case use the version of regasm found in the latest folder found under c:\Windows\Microsoft.NET\Framework\, not c:\Windows\Microsoft.NET\Framework64\.
Following these instructions the applications should successfully install on machines with 64 bit Windows, and be available to either 32 bit or 64 bit versions of Office.
For a good clear description of the background to these things see: http://www.samlogic.net/articles/32-64-bit-windows-folder-x86-syswow64.htm (link provided by Dennis Wallentin).