You can also do this:
Project.Variables.password.DecryptedValue
This will return the Decrypted value of your password variable.
.DecryptedValue - it's amazing! :) I am surprised why it is not documented...
If you can't avoid using a password type variable, you can use some workaround: type your password somewhere using SetText (or Keys) method and then get it from there as a string:
e.g. using Notepad:
workaround = Sys.Process("notepad").Window("Notepad").Window("Edit")
workaround.Keys(Project.Variables.yourPasswordVariable)
Log.Message(workaround.wText)
You can also do this:
Project.Variables.password.DecryptedValue
This will return the Decrypted value of your password variable.
.DecryptedValue - it's amazing! :) I am surprised why it is not documented...
Thanks for your solution. You saved my day.
Try them.
https://www.iseepassword.com/unprotect-excel-sheet-password.html
http://uknowit.uwgb.edu/page.php?id=28850
I tried it with Excel 2016and it works! And it's very easy too.
Only with a simple macro.
You don't know whether you like it until you've tried it. :-)
