Send>contents of clipboard

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
johnnygrr
Newbie
Posts: 6
Joined: Tue Feb 02, 2010 1:18 am

Send>contents of clipboard

Post by johnnygrr » Tue Feb 02, 2010 1:24 am

Hi everyone,
I want to be able to send> the contents of the clipboard onto a website drop down box, but without pasting.
E.g:

Copy:cell A1 contents (which is a formula currently displaying 80000)
go to: website multidrop down box
send>80000 (not press CTRL & V as this doesnt work)

I can get the value only data out of excel ok, i just can get it to merge into the drop down box.

The true application:
Copying a value from a spreadsheet into the "max price" drop down box on rightmove.co.uk

Any help, much appreciated! this is driving me mad! :twisted:

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 » Tue Feb 02, 2010 5:48 am

You need to use GetClipboard>

Copy the info from the cell, then do this:

Code: Select all

GetClipboard>vCellValue
SetFocus>BrowserWindow*
MouseMove>DestinationField
Send>%vCellValue%
Press ENTER
Hope this was helpful..................good luck,
Bob
A humble man and PROUD of it!

johnnygrr
Newbie
Posts: 6
Joined: Tue Feb 02, 2010 1:18 am

Post by johnnygrr » Tue Feb 02, 2010 11:03 pm

Cheers Bob,
Thats worked a treat!
J

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