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" <IvanLozada@discussions.microsoft.com> wrote in
message
news:B52D3ED6-2861-4287-90DE-3EC079385C0A@microsoft.com...
> 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