Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bad Excel error on Close
Message
De
23/08/1999 17:00:34
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Bad Excel error on Close
Divers
Thread ID:
00256799
Message ID:
00256799
Vues:
48
I think I know why this is occuring but I not sure how to fix it
Background--
In VFP3
Ive got a program that does some calculations and then calls another 'excel pasting' program. The pasting program takes the currently opened dbf and Pastes the dbf contents into an excel template or spreadsheet starting at a specific cell. The pasting program ends like this
oExcel.Visible = .T. && so user can see it
release oexcel
return

Then the calling program does some maintainance activity..updates.. replace etc...... before if ends.

My problem--
When the pasting program returns to the calling program I get the error 'Excel has performed an illegal opperation'.
While this is a non fatal error and doesnt affect foxpro or the data it is obviously unwanted and has netted me 2 calls today by users who were afraid they did something wrong. I think it has to do with releasing the object before I quit the application-- but issuing an oxecel.quit after Oexcel.visible will close down the application immediately. Any suggestions?


Thanks for your help
Brian
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform