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