Variable Not Defined error in VBA for CurrentDb function for access DB

Question

I am using currentDb method to get instance of database in VBA excel macro. I have added reference as well but CurrentDb method is giving error "Variable Not Defined"

Below is code

Dim Db As DAO.Database

Db = CurrentDb

Could you please help me on this

CurrentDb is an Access method, so it's not going to work by itself in Excel VBA. Maybe if you posted more code someone might have a suggestion. With only two lines not much to go on. — Tim Williams
– Tim Williams, Commented Sep 11, 2018 at 6:19

andrew · Accepted Answer · 2018-09-11 06:36:33Z

4

CurrentDb is an Access-specific global variable which is not defined in Excel.

You need to open a database instead:

Dim Db As DAO.Database
Set Db = OpenDatabase("C:\Users\Fred\Databases\Foo.mdb")

OpenDatabase is a member of the global object DBEngine from the Microsoft DAO 3.6 Object Library (which I assume you have referenced because your code has the DAO.Database type).

answered Sep 11, 2018 at 6:36

andrew

1,8262 gold badges14 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Variable Not Defined error in VBA for CurrentDb function for access DB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related