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

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


--
Thanks

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

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

Cliff Edwards