General information
Category:
Object Oriented Programming
>I am currently experiencing a problem while attempting to create a Microsoft Excel spreadsheet containing more than one worksheet. I have no problem creating 2 separate spreadsheets, but I cannot seem to link multiple worksheets to the same spreadsheet...
>
You can add worksheets to an existing workbook, using the
Worksheets.Add method:
oXL.ActiveWorkbook.Worksheets.Add()
You can control the number of sheets in a new workbook by setting the SheetsInNewWorkbook property of the Application object:
oXL.SheetsInNewWorkbook = 5
Tamar
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only