Opening Access Database from Excel

[sh3498]

This is probably an Excel question, but I have not found an Excel site as good as this one. I am trying to run an Excel macro every morning that will run some code and then open an Access database that runs some more code and then closes. I know how to go form Access to Excel, but cannot figure out from Excel to Access. Here is what I have

Application.ActivateMicrosoftApp xlMicrosoftAccess

This opens Access, but I cannot get my database filename in there anywhere. Does anyone have any ideas?

 

[namliam]

You should look into doing this from VBA... using objects...

Regards