Is it possible to click on View or File options present in Excel sheet using QTP
What are you trying to do?
In an excel there are options like
at the top , i have to click on the option using QTP and then after that select a vlue from the dropdown
Is this possible?
One Option is Use Window's Shell scripting to Navigate the ToolBar's
Can you please provide me a sample code?
What validations u need to perform, Is it on the data in excel.
Winds of Change
@Dipti : Can you record a macro using excel itself?
RSS Feed : Break To Make it Better
A Lazy person could be the best automation professional, if he is not lazy in implementing his ideas to reduce his work. ~Anand Tambey
@Anand: The Click action on menuitems does not get recorded in Macro Recoring.
Please let me know if you were successful in recording the actions and if i need to make any changes to settings in order to make the recording successful
Are you trying to create a list dynamically and select a value? If possible attach a snapshot on what you are trying to accomplish, for a clear understanding.
@Dipti : Macro/QTP is not of much use for your scenario.
However you can achieve data validation in programmatic way using VBA.
See this post - http://www.automateexcel.com/2004/08/14/title/