Hello ,
I am getting an error when testing the macro in Window 7.
My excel VBA macro created a tempdao.xlsm file on destop but the macro is not able to find it eventhough the file is there. It get stuck on this line of code:
Set db= open database("c:\tempdao.xlsm, false, true, "Excel 12.0;HDR=YES;")
No one in our team is able to figure it out. It has something to do with the new version of Excel and window 7.
I am getting an error when testing the macro in Window 7.
My excel VBA macro created a tempdao.xlsm file on destop but the macro is not able to find it eventhough the file is there. It get stuck on this line of code:
Set db= open database("c:\tempdao.xlsm, false, true, "Excel 12.0;HDR=YES;")
No one in our team is able to figure it out. It has something to do with the new version of Excel and window 7.