Hello slingee,
It looks like everyone here has exhausted some of the most common reasons for your error, but I think I missed what error exactly you were getting? (Forgive me if this is in a previous post somewhere, I didn't see it). The example you refer to does not require the report generation toolkit or anything from the addons directory. Rather, it uses straight ActiveX calls. I assume that you are trying to run the exe on the same computer as the development environment (eliminating any conflicts with different versions of Excel).
Based on what everyone else has suggested, the only thing I can think of at the moment is the way the file path is handled. The example is inside an .llb, which means you have to strip the current vi's path twice to get a valid file path for the .xls file. If you build the VI as-is into an exe the same rule applies -- only this time the VI is "inside" the exe instead of an .llb. If you are working on a modified version of this example and have changed the strip path's that could easily be the source of the error.
I have compiled the Excel macro example into an exe myself (see the zip file attached below). Does this return an error on your computer? If so, which one? Can you compile the example as it is shipped without error?
Hope this helps,
