Forum Discussion

siv_arunprakash's avatar
siv_arunprakash
Contributor
7 years ago

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

Marsha_R's avatar
Marsha_R
Moderator
7 years ago

Is the password protection part of the test?  I would try finding a way to make your own test copy of the workbook that isn't password protected.  It might take some data masking or cleanup but that may be easier than worrying about this password.