manage windows control

[jjj]

hello,

has anyone tried using the mwc to capture the Insert drop down within excel 2007? i cant seem to get it using the capture. should i use the record option instead since it's a two step process? i want aa to capture the insert drop down and choose insert column in the menu. let me know if you can help with this, thanks.

[forumstaff]

Hello,

Thank you for passing the information about Manage Windows Control not able to capture objects on Excel files. Our development team will have a look at this issue and try to find viable solution.

However please try using keystrokes to select the insert functions available in excel.

Let us consider we need to insert row in a excel file.
• Please open new excel file by the title Book1,
• Enter some values in first 5 rows.
• Select one cell in 3rd row.
• Please try below mentioned keystrokes.

1 Keystrokes: [ALT DOWN]h[ALT UP] in "Microsoft Excel - Book1"
2 Delays: (500 ms)
3 Keystrokes: i in "Currently Active Window"
4 Delays: (500 ms)
5 Keystrokes: r in "Currently Active Window"

• This will insert new row above the selected 3rd row.

To find the right keystroke for the control just press ALT keystroke in your keyboard, excel file will highlight the letters to reach to our required command.