JSSenior
asked on
Open Access 2007 from Excel 2007 vba
Is there Excel 2007 vba code that will open an Access 2007 database and then trigger a saved import to the Access DB (from a different Excel SS)?
If you have any problems
Set db = acApp
Not: Set db = CurrentDb
Set db = acApp
Not: Set db = CurrentDb
ASKER
Hi sorry for the delayed reply. Im getting a run time error 7866....MS cant open because its missing or opened exclusively or it is not an ADP file.
It's Access 2007 any idea's?
It's Access 2007 any idea's?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm not sure about that error code, it sounded like you didn't have the path and file name correct. Did you include the file extention? the .mdb or .accdb or w/e?
-SA
-SA
ASKER
Access 2007 basic file extention ACCDB
awesome guys, this also worked for me. Thank you and cheers
Open in new window
Then just have a proceedure in access (you likely already have one) that you call using the above code. GL!