Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to add a new sheet in a worksheet in VPF9 ?
Message
From
02/01/2016 07:47:43
Marcia Akins
Arkansas, United States
 
 
To
02/01/2016 00:00:25
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: How to add a new sheet in a worksheet in VPF9 ?
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP3
Network:
Windows Server 2008 R2
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01629519
Message ID:
01629527
Views:
54
I found the Excel Macro command is
Sheets.Add After:=Sheets(Sheets.Count)
how to convert it VFP 9 coding ?

If you are creating a new Excel file from scratch:
oXL = CREATEOBJECT('Excel.Application')
oWB = oXL.Workbooks.Add()
oSheet = oXL.Worksheets.Add()
oSheet.Name = "Foo"
oSheet = oWB.Worksheets.Add()
oSheet.Name = "Bar"
Previous
Reply
Map
View

Click here to load this message in the networking platform