Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
QTP + Excel + Titus protection
#1
Not Solved
Hi All,
recently our company added TITUS protection to Excel.
My script that creates excel file is now stucked in the step where the file is saving because a new popup is displayed with the options for document classification...

Any advice how to control the popup (it is excel popup)?

Until now i tried to control it with keypresses (P + Enter is working for me manually) but without any success.

Proper way will be to focus the popup and choose proper value in combobox and confirm with button OK.

Please if you can advice me how to control popups from excel file.
Thank you
Reply
#2
Not Solved
Hi All,
I was able to find simple solution for my issue.

1) create shortcut in excel on host machine for the QTP sript
2) right after the worksheet is created call the shortcut with the sendkeys method in object WScript.Shell
3) edit the excel and save it with method "Save.As"
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)