Pulling a Query from Excel via Access

I am trying to write some VBA code that pulls an Acess query I have already designed in Access through the Query function of Excel. I have successfully written one that does this but need some help in kaing one of the words a variable. You see, I have multiple queries and would like my macro to know run through them using a string variable that I give it. When I run the following code, I get this error: "General ODBC error", and the debugger highlights the very last line of the code below ".Refresh BackgroundQuery:=False"

PLEASE HELP! Thanks!

Please Login or Register  to view this content.

Nevermind, I found my own stupid error and it works.