General information
Category:
COM/DCOM and OLE Automation
>>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
Jamie,
I am confused. AFAIK, auto_open macro does not fire while Automation. It works 'automatically' upon open document manually only. What kind of auto_open macro do you have?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only