I am in trouble !!!!
I have the following code:
Dim toDB as DAO.Database
Set toDB = DBEngine.OpenDatabase("C:\mydb.xls", False, False, "Excel 8.0;")
it works fine my Excel used to be Excel 2003 and my program that is ran in a company for over 5 years works with no headache !!!
We upgraded all over to Excel 2007 and obviously C:\mydb.xls is now C:\mydb.xlsm
I am not able to get the above instruction to work no matter what I did. I change the connect string to "Excel 12.0;" and it is not working I am getting
Error 3170 Could not Find Installable ISAMS
How to get DAO to access Excel 2007 .xlsm