Forum Discussion
baxatob
7 years agoCommunity Hero
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)
- tristaanogre7 years agoEsteemed Contributor
You can also do this:
Project.Variables.password.DecryptedValueThis will return the Decrypted value of your password variable.
- baxatob7 years agoCommunity Hero
.DecryptedValue - it's amazing! :) I am surprised why it is not documented...
- siv_arunprakash7 years agoContributor
Thanks for your solution. You saved my day.
- Stephenflemming6 years agoOccasional Visitor
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. :-)
Related Content
- 3 years ago
- 3 years ago
Recent Discussions
- 43 seconds ago
- 11 hours ago