Hello Lifesavers,


I'm hoping this is simple, as I believe it is common....

I have an Access Query, we'll just call it QueryA.

All I want to do is have VBA code on an ActiveX button so when it presses, it runs QueryA from Access, then pastes the results on an excel sheet. We'll say I want it to paste it onto Sheet1 in Book1.

I have the QueryA SQL code (from what I read that might be needed), and the path to the file on hand. But outside of that, I have no clue where to start with the VBA code.

PLEASE HELP!

Thank you!!