Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling how a second excel file opens
I have an Excel workbook I use to aggregate data from other excel workbooks.
My macros copy data from the secondary workbook and appends the data to the primary workbook. My question: Is there the capability to open up secondary workbook without the secondary workbook executing any of it's macros and not do any calculations? Is there a better way to pull data from another excel workbook? Links are not an option. Thanks, - Pat |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling how a second excel file opens
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling how a second excel file opens
Pat, You could move the Workbook_Open code (secondary workbook) to an Auto_Open sub in a standard module. An Auto_Open sub runs when a workbook is opened normally (manually) but does not run when the workbook is opened via code. Also, just changing Application.Calculation to manual before opening the workbook should keep it quiet. Ron de Bruin (MVP) has some ADO code... http://www.rondebruin.nl/ado.htm that can be used to extract data from closed workbooks. I have never had cause to use ADO yet. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Dreiding" wrote in message I have an Excel workbook I use to aggregate data from other excel workbooks. My macros copy data from the secondary workbook and appends the data to the primary workbook. My question: Is there the capability to open up secondary workbook without the secondary workbook executing any of it's macros and not do any calculations? Is there a better way to pull data from another excel workbook? Links are not an option. Thanks, - Pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel file opens and opens and opens | Excel Discussion (Misc queries) | |||
Opening file in Excel 2003 opens multipule instances of same file | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
Controlling VB executable from Excel File | Excel Programming | |||
Double Click .xls file in Explorer opens Excel but no file | Setting up and Configuration of Excel |