Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to add a new sheet in a worksheet in VPF9 ?
Message
De
02/01/2016 07:47:43
Marcia Akins
Arkansas, États-Unis
 
 
À
02/01/2016 00:00:25
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Re: How to add a new sheet in a worksheet in VPF9 ?
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP3
Network:
Windows Server 2008 R2
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01629519
Message ID:
01629527
Vues:
55
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"
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform