Problem with deploying excel automated application developed in VB.NET , excel.addin , office.automation , excel London, United Kingdom
  • 12 years ago
    I am experienced in developing vba code within Excel, but I am a novice with I have created a new "Excel 2007 Workbook" project using the installed template in VS2008. Apart from a few initial config difficulties, I have succeeded in setting up a new workbook, and have developed quite a lot of code behind my worksheets. Everything works fine within the VS2008 environment. So, now that it all works, I want to use the worksheet outside of the VS environment, i.e. by just opening the .xls file. However, when I open the workbook in Excel by double-clicking the .xls file in the bin\debug folder within the project, the spreadsheet opens fine but none of the vb code runs. The buttons in the sheets, which all work perfectly when in VS2008, are completely dead. Could anyone tell me how to activate the code behind the sheets outside of the VS2008 environment. Thanks for your help.
  • 12 years ago
    Veritant, The only thing that springs to mind is perhaps unsigned macros are disabled? (Excel Options|Trust Center|Trust Center Settings|Macro Settings) Let us know if that works or not! :) James
  • 12 years ago
    Hi James - thanks for your response. It doesn't look like it's a macro disablement problem - I have that set to allow all macros to run. After further research, it seems there is a pretty complex deployment process that I have not yet understood. Apparently deployment of the .net application involves setting up a Setup project which installs all the required components and registers them in some way. I am still having a lot of difficulty getting even a very simple add-in to work. O for the simple days of vba!

Post a reply

Enter your message below

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Never trust a programmer in a suit.” - Anonymous