colham1956
Programmer
I have an Excel spreadsheet with a macro that needs to open an Accpac V5.5 (MSQL) database, generate a FR report to file, close the database and then sequentially repeat the process to another five databases. based on testing my macro code works fine for the first database connection only - it is not closing the first Accpac session before trying to open the second Accpac session (the second FR report attempt) keeps accessing the first database opened. I think I need some VB code examples to properly close the first Accpac session. Any hints???