How to execute a excel subroutine from visual basic

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

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" <[email protected]> wrote in
message
news:[email protected]...
> 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