How to execute a excel subroutine from visual basic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


message
news:[email protected]...
 
Back
Top