I was trying to close Excel from VB 6, or VBA and reopen the same workbook when the routine was run again.
This was made impossible as the Excel process would stay alive (observed on the Task Manager) no matter how much closing
I did.
After trying all the possible answers (thanks, guys!) I had...
Nice to belong to such a group. I have been scanning your pages for a long time now.
I have an Excel workbook that is linked to an Access table. The table link is set to refresh when the workbook opens.
This works fine once I used...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.