Automation with Excel Multiple Worksheets

[campbere]

I have a 6.0 VB application that sends information out to an Excel Workbook. I have been able to automate the process as long as I know the number or worksheets I need. However now I need to learn how to use the VB OLE Automation to create X amount of worksheets.

Each time the report is ran the number of worksheets can be different. For example this report grabs all the products, and their relevant information that are currently in production. For each unique product it's data should be on a seperate worksheet.

I have not figured out how to do this dynamically. Can someone give me some hints or push me in the right direction?

Thank You

 

[MaxZak]

You can simply add a new worksheet avery time you need:

Dim newWorksheet as Excel.Worksheet
Dim myWorkbook as Excel.Workbook

...

set newWorksheet = myWorkbook.Sheets.Add

or something like that...