This is very similar question to question 31 in the knowledge base. I am hoping that some one has come up with a better solution in 9 years.
I want to launch a macro express macro from excel, VBA. I first thought it would be simple by launching via the commandline and pass along some variables, but have not figured out how to launch dos command from excel. Excel does have the capability to send DDE commands via vba and wondered I can do something similar with Macro Express. Here is an example code of DDE Execute from Excel to Word
channelNumber = Application.DDEInitiate( _
app:="WinWord", _
topic:="C:\WINWORD\FORMLETR.DOC")
Application.DDEExecute channelNumber, "[FILEPRINT]"
Application.DDETerminate channelNumber
I would also need to pass along some variables.
Any clue how I can launch a Macro Express macro from Excel?
Thanks
CryptOrchid