Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call VBA procedure ilocated in another workbook
Hi - is there a way to call an Excel VBA procedure located in another
workbook? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call VBA procedure ilocated in another workbook
Yes. BUT, the other workbook must also be opened in Excel for this to work.
Now, if the other workbook is not yet open, Excel will attempt to open it. If it doesn't find the workbook, you get an error message. If Excel does find the workbook and successfully opens it, the workbook_open or auto_open procedures will also execute. This will run the procedure named "Test" that's inside a module in Book1.xls Application.Run "Book1.xls!Test" This will run the procedure named "Test" that's inside Sheet1 of Book1.xls Application.Run "Book1.xls!Sheet1.Test" " wrote: Hi - is there a way to call an Excel VBA procedure located in another workbook? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
procedure call | Excel Programming | |||
Call a procedure in the workbook from a worksheet | Excel Programming | |||
Where else to look for procedure call | Excel Programming | |||
call procedure | Excel Programming | |||
procedure won't call | Excel Programming |