Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why won't form release
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00400449
Message ID:
00401016
Views:
32
>For what its worth, I found that if after creating the Excel object, I create a file object and don't do oFile.close() then oExcel.quit() then release the objects, the oExcel object won't release from the system.

When you attempt to quit Excel with a new file that has changes, I think Excel displays a dialog asking if you want to save. Since Excel would be in a wait state, that would be why it doesn't release.

FWIW (also), I found that if you save a file in Excel under a new name (Save As) and another with that name exists, Excel will throw a dialog up asking if it should overwrite. VFP does this unless you have SAFETY OFF. I couldn't find any way to tell Excel to overwrite this programmatically (I delete the exisiting file prior). This is just another place that a wait state could cause you problems.

If anyone knows what arguments to send to the SaveAs method, I'd be interested.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform