View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
supemsd supemsd is offline
external usenet poster
 
Posts: 1
Default I cannot close a workbook in vba, I think because it odlinked to

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.