Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Saving a spreadsheet using Automation
Message
 
To
04/11/2004 16:52:42
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00958188
Message ID:
00958428
Views:
15
I'm not 100% sure. But I noticed in Excel Automation that if you are trying to interact with a lower level (down to the work sheet for exemple), that it works better to go to that lower level, rather than trying to work it "from above". Sorry I don't have a better explanation, other "This technique seems to work".


>Mike--
>
>>Try referencing the workbook itself to see if it solves your problem
>>
>>
o = GETOBJECT(,'excel.application')
>>owb = o.ActiveWorkbook
>>owb.saveas(("c:\SamSludge.txt")
>>
>
>Your code worked (an extra left paren though). Can you explain why your code worked and my code
>
> o.ActiveWorkbook.SaveAs ("c:\SamSludge.txt")
>
>did not work?
>
>
>Thanks.
>
>
>Tim
Previous
Reply
Map
View

Click here to load this message in the networking platform