Access query from excel VBA

[BChumie]

Hello,

Can I run an access query from VBA? If so, could I please get some direction on how to do this?

Thanks,
Brad

 

[KellyK]

Brad,

Try this line:

DoCmd.OpenQuery "queryname"

Kelly

 

[BChumie]

Thank Kelly,

That works in Access but It doesn't work if I am trying to open that query from excel. I am sorry I was unclear on how I asked the question. Basically I need to run a macro in excel that will run a macro in Access then return back to excel to distribute some data.

Brad

 

[KellyK]

Oops. this is why it helps to read the subject line of the post!