Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Worksheets....
Message
From
09/07/2002 13:32:24
 
General information
Forum:
Visual FoxPro
Category:
Object Oriented Programming
Miscellaneous
Thread ID:
00676667
Message ID:
00676746
Views:
16
>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
Map
View

Click here to load this message in the networking platform