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

dan
Thu May 08 18:10:55 CDT 2008

Hi Pat,

See if this works for you:

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

Dan

Jim
Thu May 08 19:30:29 CDT 2008


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" <Dreiding@discussions.microsoft.com>
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
Thu May 15 06:55:01 CDT 2008

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

- Pat

"Jim Cone" wrote:

>
> 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" <Dreiding@discussions.microsoft.com>
> 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
>
>
>