Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Worksheet Titles or Names...
Message
De
16/07/2002 14:20:48
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Programmation Orientée Object
Divers
Thread ID:
00679244
Message ID:
00679262
Vues:
17
>I am currently running into difficulty while trying to rename each of the individual worksheets within a multiple worksheet workbook. Any assistance would be gladly appreciated....
>
>Thanks
>
>Maurice B Bernhard
* VFP7 code
Local loXL AS Excel.Application, lnIndex

loXL=CreateObject('Excel.Application')
loXL.Visible= .t.
loXL.Workbooks.Add
For lnIndex = 1 To loXL.ActiveWorkbook.Sheets.Count
	loXL.ActiveWorkbook.Sheets(lnIndex).Name = 'sheet_'+Transform(lnIndex)
EndFor
HTH
Zlatin Zlatev,
MCSD (VS6)

Make solutions, not programs!

Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform