Introduction In this post we describe a technique that allows your Excel addin to be loadable by 32 bit Excel, but lets you run calculations that require more than 2GB of RAM. Most people in financial industry use 32 bit Excel even though they are running it on 64 bit Windows. The main reason for this is backward compatibility - if you have a set of 32 bit addins that you used with previous version of Excel you’ll stick to 32 bit Excel when upgrading.
- Introduction It happens often: you compile your xll addin and give it to yor client just to hear them complaining that they cannot load the xll into Excel. The error that they see is: “The file you are trying to open, ‘MyAddin.xll’, is in a different format than specified by the file extension. Verify that the file is not corrupted and is in from a trusted source before opening the file.
- When you distribute your program, library, or xll addin it is usefull to have a function that can tell you when your project was compiled. This way you can ensure that the new program, library, or xll addin is correctly installed on a user’s system. In this post I will describe how to set up such function in your Visual Studio C++ project. Create timestamp.h with the following content: 1 2 3#include <string> std::string TestTimeStamp();