Run VBA macro to drive Excel report on intranet
Posted on 2011-02-16
I have written a VBA module which creates a report on a spreadsheet, based on the user's selection of criterion from 3 dropdowns. The macro is triggered by a click on a button which appears on the spreadsheet. The program resides on our reports server and works perfectly in native Excel, but it does not run correctly when I connect to it via a link from our intranet. It does not give any errors - it just does not do what it's supposed to do when the button to create the report is clicked. Our intranet software is BancWorks.
Can anybody give me any insight on how to solve this issue or tell me whether an Excel VBA macro can even be run from an internet website?