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