Dynamically generating sheet name during export to excel...

[Grant]

I was wondering if there was any way to dynamically name the worksheet you create when exporting to an exisiting Excel workbook. I don't want to replace the worksheet or append to it, I need a new one created. I would be using this in Datapump to run against a series of reports. Thanks

[Gareth Horton]

Grant,

If you have MDP7 or higher then this is possible.

You have macros available for:

4 digit Year
2 digit Year
Month
Day
Hour
Minute
Second
Input File Name
Job Number
Process Name
System-wide counter

Gareth


Originally posted by Grant:
I was wondering if there was any way to dynamically name the worksheet you create when exporting to an exisiting Excel workbook. I don't want to replace the worksheet or append to it, I need a new one created. I would be using this in Datapump to run against a series of reports. Thanks