You have not said what methods you used, but for the workbook your should use:

Dim wb As Workbook

Set wb = Workbooks.Open("C:\WORKBOOKNAME.xls")
wb.Close

Set wb = Nothing

Then, the workbook you opened will be definetely closed.
--
Regards
Robert
Find me at www.msofficegurus.com - be part of it!


"supemsd" wrote:

I have tried almost everything to close a workbook in vba. This workbook has
content from a running module in Access, and is linked to a table in an
Access database. I set the object to nothing at the end, quit the workbook
even quit the Application with no effect. Error is observed when i attempt
to repopulate the same workbook and the global for the first variable is
exceeded. I also saveas before the closing. Nothing seems to work.