Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to get the list of sheet names in Excel
Message
From
09/12/2003 09:56:48
 
 
To
04/12/2003 04:41:13
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00855733
Message ID:
00857182
Views:
23
Thanks Cetin.

>>Hi all,
>>
>>How do I get the names of all sheets in an excel file from VFP?
>>
>>TIA.
>
>
>*..
>With ox.ActiveWorkbook
>  Local array aSheetNames[.Sheets.Count]
>  For ix=1 to .Sheets.Count
>    aSheetNames[ix] = .Sheets(ix).Name
>  EndFor
>endwith
>
>Cetin
ramil
~~ learning to stand still
Previous
Reply
Map
View

Click here to load this message in the networking platform