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:
00401032
Views:
15
>I was trying to create an object of an excel97 range. when the range name is not found the form error event is invoked to trap this ole error(1426), give the user a message close the file and quit excel and return to the form to select another file. I have set oExcel=.null. because I have not had any trouble with the excel object being released from the system.

I don't know if this applies to Excel 97 or not, but in Excel 2000, if you iterate through a range object using a FOR EACH oCell IN oRange...ENDFOR construct, there's an object reference that gets left behind and the only way to get rid of it is to either issue CLEAR ALL or quit VFP.

Regardless, it sounds like there's a dangling object reference around here somewhere. I think David Frankenbach's web site has a utility that'll help you track it down. I don't know the URL of his site off-hand.
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform