storing Passwords


storing Passwords


I've got an Excel App with 20-25 datasheets. Obviously we don't want to login for every datasheet and we don't want to store the passwords in the ODBC settings. Anyone out there got a simple routine to store the user and pw from the first login and then use that for the rest of the datasheets?

Thanks, Phil

Re: storing Passwords

There are many ways to store userid/password.
below are few ideas......

1. you can set the variables a global variables and ask userid and password when they open the workbook.
2. ask userid and passwd when they opens excel and store then in a hidden sheet,delete them before you close the worksheet.
3. you can use temp files to store userid/passwd and delete them when cloesed.

let me know if these are useful for you.

-- Sparan