Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro call, one workbook to another
Hi -
I have two workbooks in an application. Book "One" opens before "Two". (a macro does this.) There are functions and subs in general modules in book one, that I want to run from the Open event in book two. I don't want to have to copy the code and have it be in two 'places. Application.Run("MYCUSTOM.XLM!My_Func_Sum", 1, 5) I tried to modify the above application.run example from the help section. The line below was a flat out guess. Artemaint is the module containing the zpend_qtyf function which returns an integer. ' line below is to be part of a sub executing from the ' booktwo.xls open event. PendQty = Application.Run("bookone.xls(artemaint)!zpend_qtyf ") If it's possible, please provide an example of the correct syntax. I looked at the help for "Call" and it said nothing about what I'd like. The problem will go away when booktwo becomes an add-in for bookone, but I'm not there yet. As I write this, I'm heading into Walkenbach's book, but I'm not optimistic about finding a reference quickly. Thanks much. -- Neal Z |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to call macro from other workbook | Excel Programming | |||
Call Macro from another WorkBook? | Excel Programming | |||
How can I call a macro in another workbook? | Excel Programming | |||
Open Another Workbook and Call Macro | Excel Programming | |||
Call a macro in other workbook | Excel Programming |