problem tabbing on a secondary popup Excel Window...

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
Capstan
Newbie
Posts: 3
Joined: Fri Dec 14, 2007 7:37 pm
Location: Vancouver, Canada

problem tabbing on a secondary popup Excel Window...

Post by Capstan » Fri Dec 21, 2007 1:20 am

Hi
To keep the description brief, I have an Excel application that has its own toolbar menu. The steps I want to do which I believe is quite simple but somehow I've been struggling with it
1) Open the main Excel application - DONE
2) From the toolbar menu, use shortcut key ALT | b - DONE
3) another pop-up excel Window appears - tab 6 times to get to a radio button ??

//Run Main Excel application
Run>\\network path\myApp.cmd

//Wait for 'Microsoft Excel - myApp'
Wait>5
WaitWindowOpen>Microsoft Excel - myApp
SetFocus>Microsoft Excel - myApp

//Click 'New Bids' button in myApp toolbar menu
Press ALT
Send>b

//Wait for 'Bid Worksheet Properties' pop-up Window
Wait>5
WaitWindowOpen>Bid Worksheet Properties
SetFocus>Bid Worksheet Properties

I tried both the
1) SetCheckBox>Bid Worksheet Properties, Import the following XML file:, TRUE
PushButton>Bidding Worksheet Properties, Browse...
and
2)
//Tab 6 times to get to the Import xml file radio button
Wait>5
Press Tab*6
Send>SPACE

When i'm in debug I step through the line of code it stuck when the popup window appears???

Thanks

User avatar
Bob Hansen
Automation Wizard
Posts: 2475
Joined: Tue Sep 24, 2002 3:47 am
Location: Salem, New Hampshire, US
Contact:

Post by Bob Hansen » Fri Dec 21, 2007 1:37 am

I don't think this is the cause, but you need to Release the ALT key:

Press ALT
Send>b
Release ALT

--------------------------------
Send>SPACE may be sending the letters S P A C E,

Try this instead
Send>%SPACE%
Hope this was helpful..................good luck,
Bob
A humble man and PROUD of it!

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts