Posts by ghynes

    hey folks,

    i have imported external data (odbc) to my excel sheet but everytime i open the worksheet and click refresh data, it prompts me for a login id and password. does anyone know of a macro that will refresh the data and connect to the database when i open the worksheet so i wont have to keep inputting the login and password everytime?