Change query criteria via Excel macro

[mikeymay]

I have managed to build a macro that will run a query I have in Access but what I would like to do is be able to change some of the query criteria using the macro script or any other way possible.

Is this possible?

Thanks