ADOODB Connection error Excel 16 32, bit OLE DB providers

Connection String for Excel 2016 32 bit. The script work without a problem on Office365 Excel version,
When the same file is sent to a different user with excel 2016. It get Connection initiation error. "An Error occurred after the connection was established" .
Sometimes the error is even weird. "The file is already opened.All modification will be lost, would you like to reopen the file? Yes or No".
I am unable to reproduce this error on my side O365 excel.
The data source file is the same excel. It is an .xlsm file
I checked for the dependency Microsoft ActiveX DataObjects 6.1 Library is checked.
This is the connection string that I use (It was xml before I changed to Macroin the extended properties)
Filepath = ThisWorkbook.FullName
cn.ConnectionString = _
"Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & Filepath & ";" & _
"Extended Properties='Excel 12.0 Macro;HDR=YES';"

What Should I do to check on the user's system to verify the dependency are met for ADOODB to use Excel and SQL?

0 answers