>Whether /import .... XL8 SHEET sheet_name/ does not do what you need?
>Additionally you could use Excel Automation to gather all Sheet Names and then process them as needed. Like:
>ObjExcel= CREATEOBJECT("Excel.Application")
>with ObjExcel
>.Workbooks.Open("c:\book1.xls")
>for ia=1 to .Worksheets.count
>?.Worksheets(ia).NAme
>.....
Thanks - I'll have to use the automation even though it gets me back to my original problem of not wanting the auto_open macro to fire when opening the workbook with automation .
Cheers,
Jamie
Cheers,
Jamie