1 Reply Latest reply: May 15, 2014 10:00 AM by Gareth Horton RSS

    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

        • Dynamically generating sheet name during export to excel...
          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 /b[/quote]