Use a variable when connecting excel to access with vba

I have had great success connecting to a access file through vba! However I am at a point where the column that I and querying could change. I would like some help altering me code. Thank you!

Please Login or Register  to view this content.

I have also tried

Please Login or Register  to view this content.

but it didn't work either

See attached for the error message

Just so you know if I don't use a variable in

Please Login or Register  to view this content.

It works fine.

So I really need to know how to put a variable in there!

Please Login or Register  to view this content.

should do it.