Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is there a better way .... ?
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00700028
Message ID:
00701040
Views:
14
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform