| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
| how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
| my colors change in my workbook when I open another workbook | Excel Discussion (Misc queries) | |||
| Importing Data from unopened Workbook into an open Workbook | Excel Discussion (Misc queries) | |||
| What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming | |||
Threaded Mode
