I have an excel workbook with 7 sheets in it. The data in all the sheets is extracted from an ODBC connection with a DB user and password.
Each time the workbook is opened, the last set of data extracted is shown, obviously. If I need to refresh the data, I am required to put in the DB user and password for each page.
All the data is coming from the same DB so the password is the same for all 7 sheets.
I would like to know if there is a way to embed the user and pass into the workbook so that each time I refresh the data, the user and password are passed through without any need to type it in.
I was actually thinking that it would be nice to have the user and password, passed through to the DB when opening the sheets so that there is never a need to refresh the data after opening.
Is this possible?
Mark the fireman