Intercept query parameter values from data refresh

[Jim~C]

Hi,

Is there a way to determine the value a user specifies for a query parameter
when using the "Refresh Data" command? I have a External data query to an
SQL server database that contains a single parameter. I'd like to determine
what the user entered for that parameter from within Excel vba code or other
means.

I'm running Excel XP on Windows XP. Any ideas would be greatly appreciated.

Thanks in advance!
Jim