Hi Kjetil,

The WorkBook_Open event may be used to import
data and update tthe pivot tables,

For an overview of event procedures, see Chip Pearson
at:

Event Procedures
http://www.cpearson.com/excel/events.htm

To save a copy of the resultant file without theWorkBook_Open
code, save the required sheets in a new workbook, for example

Sheets(Array("Sheet1", "Sheet2")).Copy

Then, save the new worbook and close rthe original without
saving changes.

Alternatively, Chip Pearson demonstrates how code can be
removed progammatically at:

Programming To The Visual Basic Editor
http://www.cpearson.com/excel/vbe.htm


---
Regards,
Norman



"Kjetil" wrote in message
...
I struggle with a workflow that is supposed to run unattended. It includes
the following steps:

1) Creation of sdv-file from Oracle
2) Importing the sdv-file in a ready made Excel file. Updating some pivots.
3) Sending the Excel file to a colleague.

Task #1 and #3 is programmed and running unattended already, but i need help
with the Excel prosessing. I guess it can be solved this way:

a) I call the "Master.xls" which has a start up macro.
Question: It's possible to dedicate a start-up macro to a single excel-file,
right? I would appreciate any reference to have this can be done.

b) The macro is being executed (i should manage this by my own...)

c) After dataprocessing, i want to save the file as "Clone.xls". This
version of the file should not hold the start-up macro.
Question: Is it possible? How?

Thanks in advance!
Kjetil