I've been trying to figure out how to pass criteria to MS Query when
refreshing data with a macro.

I'm planning on having the criteria to be passed hard coded into the
macro, along the lines of:

Refresh All with STATE = 'WI'
(or sometimes
Refresh All with STATE = "WA" or "OR")

When the refresh is done, 'save as' the workbook without the embedded
query and without the macro in the spreadsheet as
'filename-passed-criteria' and then do another refresh with another
set of criteria, save it as a seperate file, and so on.

Also, there's more than one Get External Data instance in the
spreadsheet that will have to have criteria passed to it.

I hope someone can help point me in the right direction!

thanks