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