Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Spreadsheet update
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00317983
Message ID:
00360987
Vues:
9
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform