Call Excel Macro

08-08-2002, 12:37 AM
Hello, guys,

If I have an excel macro, can I make VB to call it directly instead of going through re-writing the program from scratch?

I just want to make an executable program through VB and call the excel macro directly.

Thanks a lot.

08-08-2002, 07:16 AM
You can use excel's Run method

YourXLApp.Run ("YourMacroName", Optional argument1,Optional argument2, .....)

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum