Controlling how a second excel file opens

[Dreiding]

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

 

[dan dungan]

Hi Pat,

See if this works for you:

http://www.erlandsendata.no/english/index.php?d=envbatextimportwb

Dan

 

[Jim Cone]

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" <[email protected]>
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

 

[Dreiding]

Thanks, The ADO approach is exactly what' I need.

- Pat