>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
local oExcel as Excel.Application
oExcel= create("Excel.Application")
oW = oExcel.Workbooks.Open("c:\...\....\filename.xls")
for I = oExcel.Worksheets.Count
? oExcel.worksheets[m.I].name
endfor
I hope this helps.
Am I going to see you next week in Phonix??
Peter
Peter Cortiel