Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Odd Excel behavior while being controlled from VFP
Message
From
05/04/2004 15:45:01
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Odd Excel behavior while being controlled from VFP
Miscellaneous
Thread ID:
00892421
Message ID:
00892421
Views:
58
I'm creating and running an instance Excel from inside a VFP executable. The code that instantiates Excel is:
this.oExcel = CreateObject( 'Excel.Application' )

I do pass the object reference to another object like this:
oRef = this.oExcel

Then I release the object referred to by "this", without exiting the VFP application. What I'm seeing is this:

If I quit Excel while the VFP application is running by going to File>Exit and then run the report that instantiates Excel again, when Excel opens, it retains a screenshoot of the application from the first time it ran. You can't see the new report that is supposed to be generated. My guess is that Excel is not releasing completely when the old report object is destroyed.

I'd appreciate getting some ideas on how to get Excel completely gone while still being able to pass Excel to a new object reference.

Ideas anyone?

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform