Hi,

You may try the approach below.
1. Call Excel4() (or Excel12() if you're in Excel 2007) and invoke xlfRun.
2. For the 1st arg, pass in an XLOPER of xltypeStr that contains the
fully-qualified name of the macro you want to run.

Please let me know if that did not work for you together with the exact
error code/message or error scenario description.

Thanks!

Best regards,

Perter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.