Forum Discussion

siv_arunprakash's avatar
siv_arunprakash
Contributor
8 years ago
Solved

How to open a password protected excel workbook in TestComplete?

I used the following JavaScript:   var Excel= Sys.OleObject("Excel.Application"); Excel.Workbooks.Open(filename, 0, false, 1, "password");   This script worked, But if I set the "password"...
  • tristaanogre's avatar
    tristaanogre
    8 years ago

    You can also do this:

    Project.Variables.password.DecryptedValue

     

    This will return the Decrypted value of your password variable.

  • baxatob's avatar
    baxatob
    8 years ago

     

    .DecryptedValue - it's amazing! :) I am surprised why it is not documented...

baxatob's avatar
baxatob
Community Hero
8 years ago

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)