Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Worksheet Titles or Names...
Message
From
16/07/2002 14:20:48
 
General information
Forum:
Visual FoxPro
Category:
Object Oriented Programming
Miscellaneous
Thread ID:
00679244
Message ID:
00679262
Views:
18
>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!

Previous
Reply
Map
View

Click here to load this message in the networking platform