"Alain" wrote:

I have a workbook that extract data from an external SQL server from an ODBC
connection. Everytime I need to refresh the data, it is asking for a password
It is possible to VBA some code to automate the SQL server login from being
prompted every time we refresh the data

Thanks


Hi Alain

did you ever get this to work, i have exactly the same problem, but my
external data is in microsoft access and not in microsoft query, so just
wondering how you achived it in the end