DTS output to Excel

• Helen T

  SSC Veteran

  Points: 293

  More actions

  March 26, 2004 at 8:06 am

  #59702

  I have created an Activex Script which happily outputs to a formatted Excel Workbook. But I want more! I can't seem to find the syntax for adding extra worksheets (beyond the allocated three) to my workbook.

  Does anyone here know how to or know where I might find out?

  I'm just going round in circles here!!

   

  
  Helen

• Helen T

  SSC Veteran

  Points: 293

  More actions

  March 26, 2004 at 8:20 am

  #500663

  Sorry to be a time waster!

  As soon as I gave up and posted on here I found a script for just what I wanted at:

  http://www.erlandsendata.no/english/index.php?d=envbawbcreatenewwb

  Ain't the Internet great!!

  

   

  
  Helen