Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation in VB
Message
 
To
20/05/2003 16:56:49
General information
Forum:
Visual Basic
Category:
COM, DCOM and OLE automation
Miscellaneous
Thread ID:
00789379
Message ID:
00790844
Views:
14
Since the Worksheet is part of a workbook, it should be cleaned first:


'Close the Workbook
m_objWrkbk.Close True, "c:\test.xls"

'Release workbook from memory
SET m_objWrkSht = NOTHING
Set m_objWrkbk = Nothing



>Just for clarification
>
>>'Close the Workbook
>>m_objWrkbk.Close True, "c:\test.xls"
>>
>>'Release workbook from memory
>Set m_objWrkSht = Nothing
>>Set m_objWrkbk = Nothing
>
>I added setting the Worksheet Object = Nothing after the workbook is closed.
>
>Nichole
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform