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.
|