Thank you !
The problem is solved, I just tried with false instead of true and it works fine.
Do you have the Excel file open in Excel while you are attempting to run the code? If so, you will get the message you indicated.
Something else a bit unrelated but will save you a headache later on, after your wend, you should call the following code
Call DDT.CloseDriver(xlDriver.Name)
A best practice is to always make sure you close your driver once you are done using it. It prevents a variety of problems later on.
Thank you !
The problem is solved, I just tried with false instead of true and it works fine.
Ah, that could make a difference as well. The "true" parameter for the ACE has to do, primarily, with which version of Excel you have installed. True is for versions of excel from Excel 2007 and newer. It has to do with which database driver you wish to use.
Still, you really need to add the CloseDriver call to your code. If you don't, you may get a "max connections" error eventually.
Yes certainly, I already add it.
I'm using Excel 2016 (32 bits).
