Running an Excel Macro using the Microsoft Excel Connector
Using the Microsoft Excel Connector is trivial if you know that when you specify the Macro Name you do so by using "Modulename.Procedure" and not just Procedure. It would be nice if the online documentation reflected that.
If you only specify the procedure name you are likely to get an error message like "Cannot run the macro 'PDE17'. The macro may not be available in this workbook or all macros may be disabled."
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.