Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Spreadsheet update
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00317983
Message ID:
00360987
Views:
8
Mike,

By your comments, it sounds like excel went all the way through without stopping, and then didn't close.
I've had the intermittent problem of excel not closing. I'll take your suggestion on setting up the object
reference as public instead.

Thanks for the assist.

Dj

> Don,
>
> I experimented with your code with a spreadsheet of mine, and it appeared to run okay. However, I changed the way the Excel
> object is created. Your code is assigning an object reference to the property of a custom object. When I tested it, the Excel
> object was not being released when the application finished, leaving an instance of Excel in memory. ("RELEASE .r_oXlsSess"
> causes an error.) After several attempts at running the program, I was left with a number of Excel instances, and my system
> ended up with a GPF.

> I changed the Excel object to a public variable called oExcel, and changed all occurrences of ".r_oXlsSess" to "oExcel", and it
> appeared work much better.

> I suggest you ensure you are not creating multiple instances of Excel during your testing, and consider modifying how you are
> setting up the Excel connection.

> Good luck!

> Michael Reynolds
Previous
Reply
Map
View

Click here to load this message in the networking platform