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)
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--