Auto Fill of Forms

[gsc]

Hi All,

I am fairly new to this, I have got a job of filling forms with information from a Spreadsheet. Some of it is a simple case of copying and pasting, the rest has to be done by researching the info.

What I would like is something that pulls the info from the spreadsheet and then allows me to continue to do the researching part.

Do you have anything like this that can help me?

So imagine you have the below on a spreadsheet.....

Name: GSC

ID: 1234

Agreement: Corperate

Contract Version: 2011

Account Manager: GS

Code: SLIC/SLIC

Then on the website these feilds are all over the place and some of them are a look up that then loads another page where you have to type the Account Managers name to get their email address.... you click it and it goes back to the original page...

Once it has done the copying and pasting of all that I would then research other info such as what Level they are of a customer and when their agreement ends......

I get so many of these and are on such a low budget pay... just need something to make it easier..

Any help would be most grateful..

GSC

[Skitty]

Looks like you posted in the wrong forum.

Also, you're going to need to be a little familiar with autoit to really do that, there's a UDF library called winhttp.au3 which is suited for these types of things.

[gsc]

Oh? How have I posted in the wrong Forum? Where do I need to post this? I understand a little bit about it but not a great deal, once I have the base of it I am a quick learner and can develop it. I just need a push in the right direction

GSC

[gsc]

^{I see what you mean, I have moved it to the correct page! thanks for your pointer...}

[shmuelw1]

Name: GSC

ID: 1234

Agreement: Corperate

Contract Version: 2011

Account Manager: GS

Code: SLIC/SLIC

You definitely could use AutoIt for copy/pasting from one program to another.

Below is a sample script that copies the title of a field, for example "Name," finds it in Internet Explorer, copies the name data in Excel, then waits for you to click in the Name field in Internet Explorer. When you click OK it pastes the name and goes to the next Excel field.

; Click on the top-left cell in Excel before running
Opt("WinTitleMatchMode", 2) ; match any part of title
Dim $answer

While 1 ; continue loop forever
    WinActivate("Microsoft Excel") ; go to Excel
    WinWaitActive("Microsoft Excel")
    Send("^c") ; presses CTRL+c to copy cell
    WinActivate("Internet Explorer") ; go to IE
    WinWaitActive("Internet Explorer")
    Send("^f") ; presses CTRL+f
    Sleep(500)
    Send("^v") ; presses CTRL+v
    Send("{ENTER}") ; presses Enter to find the search item
    WinActivate("Microsoft Excel")
    WinWaitActive("Microsoft Excel")
    Send("{RIGHT}") ; presses Right Arrow to go to cell to the right  
    Send("^c") ; presses CTRL+c to copy cell
    Send("{DOWN}") ; go down one row
    Send("{LEFT}") ; go one cell to the left
    WinActivate("Internet Explorer") ; go to Excel
    WinWaitActive("Internet Explorer")
    $answer = MsgBox(262145, " ", "Click in the field where you want to copy the text, then click OK.") ; 262145 makes the dialog box have OK and Cancel buttons and always stay on top
    If $answer = 2 Then Exit ; exit if Cancel is clicked
    Send("^v") ; presses CTRL+v
    WinActivate("Internet Explorer") ; go to IE
    WinWaitActive("Internet Explorer")
WEnd