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.
Thanks.