Macro to Open Access File.

[ssingh75]

Dear All,

I've a Access database named "Abc.accdb", i want to open that database using Macro via Excel VBA.

pls assist.

Susheel

 

[Weaver]

Do you want to use excel to trigger access to open the db, or do you want to query the data into Excel? I'm guessing option 2

 

[Jon von der Heyden]

If you mean physically open the file:

ActiveWorkbook.FollowHyperlink "C:\Abc.accdb", NewWindow:=True

Note you need to include the full directory path as well as the file name and extension.

 

[ssingh75]

i want to Use Excel to open Access db using VBA.

Susheel

 

[Weaver]

i want to Use Excel to open Access db using VBA.

Susheel

Jon's solution does that. If that's not working for you then I think you mean you need to pull data into Excel from the Access database. Can you please confirm this, or not.

 

[ssingh75]

Thanks Weaver for the above help.

Its working fine

 

[mohsenmrds]

If you mean physically open the file:

ActiveWorkbook.FollowHyperlink "C:\Abc.accdb", NewWindow:=True

Note you need to include the full directory path as well as the file name and extension.

Thank you ??
If it doesn’t work only remove the “,NewWindow = true” from the code.