Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel error
Message
From
14/01/2014 09:37:25
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01591785
Message ID:
01591833
Views:
36
Likes (1)
>>>the task manager shows that Excel is still active! And the only way I can get rid of it is by cancelling the program and then it miraculously disappears!
>>>
>>>(I confirmed with the debugger that the catch is NOT activated after I _screen.oStuff.oExcel.QUIT(), so I assume that the statement executes)
>>>
>>>???
>>
>>That's why I don't like automation of Office. Try to work things out with excel visible first.It's possible that there's still some dialog it's trying to show - perhaps a "are you sure". Try with .oExcel.quit(0) - the parameter, IIRC, would tell it not to ask any questions.
>
>PMFJI, regarding your saying "I don't like automation of Office", how else would you go about creating a program to convert an excel spreadsheet to a .DBF? Do you know of a reliable method of "opening" an Excel spreadsheet and getting value from a cell, e.g. A-1?

http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileFormatsInVFP90.aspx
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform