11-03-2021
12:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
11-03-2021
12:31 AM
This worked for me in the past:
Dim oExcel As Object oExcel = CreateObject("Excel.Application") ' If there is more than one macro called TestMacro, ' the module name would be required as in ' ' oExcel.Run "Module1.TestMacro" ' ' to differentiate which routine is being called. ' oExcel.Run "TestMacro"