Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Capture Tabbed Pages' Names from Excel
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01428658
Message ID:
01428664
Views:
77
This message has been marked as the solution to the initial question of the thread.
If you're talking about sheet names
LOCAL oExcel AS Excel.Application, oWorkbook

lcXlsFile = FULLPATH("Whatever.xls")

oExcel = CreateObject("Excel.Application")
oWorkbook = oExcel.Workbooks.Open(lcXlsFile)
*oExcel.Visible = .T.

FOR i=1 TO oWorkbook.Sheets.Count
	? oWorkbook.Sheets(i).Name
ENDFOR
oExcel.Quit()
>I am thinking that at least one person has done the following:
>
>I want to capture the names of each tabbed page in an Excel file which contains more than one worksheet. I suppose you could say that each worksheet is named accordign to its tabbed page. That is what I want to capture. Once I capture that data into an array, I will use it in a dropdown combobox on a form.
>
>I do not have much experience with Microsoft Office Automation, so this one is a bit out of my league.
>
>Thanks,
>
>Cecil
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform