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

P

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
 
W

ward376

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

Cliff Edwards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top