Can I pass the logon credentials in a macro to a ODBC query

[Peter Cooling]

I have a spreadsheet with query to an ODBC data source

Each time the spreadsheet is opened and query refreshed it prompts for the
USERNAME an PASSWORD which in this instance are both blank.
Is there a way to pass the logon credentials in a macro? or other way of
avoiding the prompts?

Thanks

 

[ward376]

If you're using MS Query, you can save the password in the query using
the External Data Range dialog.

Cliff Edwards