View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wpiet wpiet is offline
external usenet poster
 
Posts: 23
Default Input ID & password once for multiple ODBC logins

In a 2003 workbook, I loop thru multiple sheets, each with a DB query, &
refresh the data. How can I, just once, accept the username & password & use
these for the ODBC login for each subsequent query?
--
Will