Forum Discussion

siv_arunprakash's avatar
siv_arunprakash
Contributor
7 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
    7 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
    7 years ago

     

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

tristaanogre's avatar
tristaanogre
Esteemed Contributor

You can also do this:

Project.Variables.password.DecryptedValue

 

This will return the Decrypted value of your password variable.

baxatob's avatar
baxatob
Community Hero
7 years ago

 

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