Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating spreadsheets
Message
From
14/07/2002 18:03:07
 
 
To
14/07/2002 14:42:08
Alan Harris-Reid
Baseline Data Services
Devon, United Kingdom
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00678510
Message ID:
00678531
Views:
17
>2. The OLE-created spreadsheet by default has 3 sheets. Do I have to delete sheets 2 and 3 programmatically, or is there a way to create the workbook with one sheet only? Come to think of it, do I have to create a workbook at all? Can I create a single sheet by itself?
oXL = CreateObject("Excel.Application")
oXL.SheetsInNewWorkbook = 1
oWorkBook = oXL.Workbooks.Add
...
As per your other question on Excel clashing with VFP I am not sure. Will have to look into it.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Reply
Map
View

Click here to load this message in the networking platform