Excel to Access

[Keith]

I have created a macro in an Excel workbook to do various things with a web
query, then export one sheet of the workbook as a txt file. I then get the
macro to open Access.

What I am wanting to do is:- I want my macro to, not only open Access, but
to open a specific Access Database and if possible, run a macro within that
database to import the data that I have exported from Excel.

Any ideas?

Thanks

 

[Dirk Roos]

Have a look at the "command line arguments" in the helpfile. You'll
find every argument you need for your purpose.