Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Capture Tabbed Pages' Names from Excel
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
Visual FoxPro
Divers
Thread ID:
01428658
Message ID:
01428664
Vues:
76
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform