Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reliable way to release Excel?
Message
 
 
To
21/10/2003 13:33:29
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00840734
Message ID:
00840770
Views:
17
Grigore,

It's probably just the time it takes Excel to finish writing the file to disk, flushing buffers, then the time it take Excel to unload from memory and return the memory to the O/S. This is probably especially true if you are running low on memory and some things have swapped to disk. 2-3 seconds isn't enough to worry about, you might want to provide some feedback to the user that you are waiting for Excel to shut down, before they can continue work.

>Hello, Alex
>
>You are right, running your code I get the same result.
>However, I think I miss something. Here is my code:
>
>
>* do the report here
>lcFisier.SAVEAS(lcCaleNume)
>x.QUIT
>x = .NULL.
>Thisform.Release
>
>
>If i execute the lines step-by-step in debugger, they execute almost instantaneous (including thisform.release), but if I run the form, after saving the file, my form stays on screen another 2-3 seconds, unresponsive, then releases. Do you have any idea why, please?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform