open Excel workbook from another workbook
 

Rachel,

This should do it for a general macro. I'm not sure that parameters make any
sense for the autoopen macro.

Sub RunOtherBook()

Workbooks.Open ("Pathtoyourfile")
Application.Run "Yourfilename!Yourmacroname", parameter1, parameter2

End Sub

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in


"rachel" wrote in message
...
Hi
I have an excel workbook that starts series of macros on work_open. Now
I have to open this workbook from another one, and to activate my
original workbook with paramers.
How can I Transfer a parater before open?
thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/