View Full Version : Opening Access Database from Excel


sh3498
08-28-2003, 03:20 PM
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
08-29-2003, 01:50 AM
You should look into doing this from VBA... using objects...

Regards