Hey, I am trying to pull a query from an access database into excel through VBA.

This is the code I am using:

Please Login or Register  to view this content.
However when I run the macro i get

Run-time error '-2147217904 (80040e10)':
No Value Given for one or more required parameters.

The paramiter is set:

Please Login or Register  to view this content.
Just cannot work out where I would put the code?

Any help would be much appreciated.