Accept & Use ODBC Login
 

In a workbook with multiple sheets, each with an associated DB query, how can
I have a user enter ODBC login username & password just once, then use these
to automate each subsequent login as the macro loops thru the sheets,
refreshing data in each.
--
Will