Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to execute a excel subroutine from visual basic
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel and Visual Basic | Excel Worksheet Functions | |||
Is Visual Basic the same as Visual Studio 2008? | Excel Worksheet Functions | |||
Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
visual basic in excel - | Excel Discussion (Misc queries) |