I'm curious how to best approach this situation. I have an old VBA workbook that works just fine as is. Unfortunately with the new security measures in Office 2007/2010 you get the "Security Warning Some active content has been disabled" message. I know that I can click on the message and select enable content or add it to a trusted location. Unfortunately doing this every single time is a bit of a pain for end-users. So I had created a Setup project in Visual Studio that would launch a console application that would copy the file to the templates folder then place a short-cut on the desktop to it. Maintaining it is a bother though because I don't add updates to the Excel file, an engineer does. So I have to re-create a setup.exe for 32/64 bit.
What is the best solution?
It needs to work with Windows Vista/7 32/64 bit and Office 2007/2010 32 bit and the users will vary in computer skills.