View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alain Alain is offline
external usenet poster
 
Posts: 15
Default External data and password

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