Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I retrieve the password that protects my XL workbook?

Status
Not open for further replies.

j9

Programmer
Jun 6, 2001
90
US
I protected my Excel workbook with a password and would like to use that same pw to retrieve data from SQL Server. I would like to avoid making users enter it twice. Is there a way to retrieve the value that was stored as the protection password for the workbook? I found properties such as activeworkbook.readonlyrecommended, but no activeworkbook.password.

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top