Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Automation and Excel
Message
 
To
06/02/2003 12:51:31
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00749786
Message ID:
00750033
Views:
25
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()
...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform