Calling an excel 4.0 macro from vba in Excel 2002
You can try using the run command
Run "XL4SheetName!NameOnXL4MacroSheet"
This is supposed to work.
--
Regards,
Tom Ogilvy
"Dave" wrote in message
...
I want to call an existing excel 4.0 macro in a macro written in vba in
excel 2002.
The excel 4.0 macros are quite complex so I don't want to convert them.
any ideas?
|