My Excel 2007 .xltm Macro Enabled Code runs fine as long as it does not open from the following foloder:
The error I get is this:
You can't run this program because some of its components are missing
On the other hand if I attempt to Add my template as an Excel Add-In from the Excel Options it gives me this error:
C:\Users\User\AppData\Roaming\Microsoft\Excel\XLSTART\myaddin.xltm is not a valid add-in
Even when using a different folder, it gives me the same error:
C:\myaddin.xltm is not a valid add-in
Any ideas as to how Excel can display a working shortcut to my VBA as an add-in every time I start excel?