Assuming you have a variable in your VB6 program that references
the Excel Application, you can use the Run method to execute the
sub. E.g,.
XLApp.Run "workbookname.xls!Sub_1", "Msg"
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Ivan Lozada" wrote in
message
...
Hello There,
How do I execute, say the Excel Public Sub Sub_1(msg as
string), subroutine
from a Visual Basic 6.0 Program?
Thanks,
Ivan