If you have MDP7 or higher then this is possible.
You have macros available for:
4 digit Year
2 digit Year
Input File Name
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 /b[/quote]