+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Excel popup handling (/Thread-Excel-popup-handling)
Excel popup handling - Shridevi.Salagare - 09-21-2011
Hi,
In my application when i click on one link .A excel is poped.I have to compare the values from this excel and from application.
I am saving the excel file by activating in using -
Window("Microsoft Excel").Activate
and then using the shortcut keys to save . Ctrl+s
Then comparing values.
But This code is not working fine everytime.Sometimes it works fine some times it doesnt recognise the excel object.
please help.
RE: Excel popup handling - Saket - 09-21-2011
Can you paste your part of code here?
RE: Excel popup handling - Shridevi.Salagare - 09-29-2011
Sorry for teh delay in reply.
The code is -
Code:
Window("Microsoft Excel").Activate
Window("Microsoft Excel").type micCtrlDwn + "S" + micCtrlUpI am activating the pop-up and saving it using shortcut keys.
RE: Excel popup handling - rajpes - 09-29-2011
Doesn't it ask for a name to be "saved as"?if no, then the file is already saved somewhere in your system.
If so,you can easily work with it by creating its object through "Excel.Application"