I have an asp.net 4.0 web app that loads an excel sheet and populates it with some values. In the Exel sheet I have a button which when clicked say "hello world" in a msgbox. When I run my Excel template without web app everything works
well. But when I load via web app using NPOI I firstly get prompted to enable macros (which is fine) but when it loads I get an error saying "An error occured while loading 'ThisWorkbook'. Do you want to continue loading this project".
I select Yes and my button does not work any more.
Any ideas on what im doing wrong?
Do I need to let NPOI that the sheet has VBA in it aswell?
Many thanks in advance