Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Automation and Excel
Message
 
À
06/02/2003 12:51:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00749786
Message ID:
00750033
Vues:
30
I believe, the problem is related to the osheet object and because you set it as public variable. You need to release it before closing a workbook (osheet=.NULL., release osheet), or do not define it as public.

Actually I cannot see the reason in your code to use osheet and obook as separate variables or objects. Use WITH statement instead. Anyway it will speed up the performance.

with oexcel.activesheet
mprogram1=.cells(mrow,mcol).value
......
endwith
....
ObjExcel.ActiveWorkbook.Close()
...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform