ExcelBanter - Input ID & password once for multiple ODBC logins

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Input ID & password once for multiple ODBC logins (https://www.excelbanter.com/excel-programming/424066-input-id-password-once-multiple-odbc-logins.html)

wpiet

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

All times are GMT +1. The time now is 10:29 PM.