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 |
Controlling how a second excel file opens
|
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 |
All times are GMT +1. The time now is 05:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com