Newbie help with copy from excel to web form...

[lentilbake]

Hi there everyone, very new to Autoit (about 30 mins actually) so hope someone can speed me along by helping me with this relatively simple task:

I have a spreadsheet in excel and I have to transfer data from cells in each row (string and numbers) to the relevent fields in a web form.

Doesn't have to open the spreadsheet or navigate to the web form, assume that spreadsheet and web form are up on screen.

Something very simple please so I can learn with it!

I tried doing this with VBA and sendkeys but was too erratic.

Many thanks in advance

[Piyush]

You can do this easily with the help of the udf provided with the autoit

open help file

go to user defined function

see excel management for functions

you can open your file with _ExcelBookOpen

read the value of the cells and store it in a variable with _ExcelReadCell

and the write the value to specific cell with _ExcelWriteCell

you can use the internet explorer udf for your webform purpose

Edited July 8, 2009 by Piyush

[lentilbake]

Many thanks for your prompt reply, glad to know that AutoIt can do this and I will try to follow your guidance but I may need a bit more help with the code, as I said, I'm only an hour into AutoIt! Maybe I'll get back when I've done a bit of experimenting

Edited July 8, 2009 by lentilbake

[Piyush]

  On 7/8/2009 at 6:18 PM, 'lentilbake said:

Many thanks for your prompt reply, glad to know that AutoIt can do this and I will try to follow your guidance but I may need a bit more help with the code, as I said, I'm only an hour into AutoIt! Maybe I'll get back when I've done a bit of experimenting

if you are not able to understand any function just read the help file. it is a very good source, i have also learned autoit from there only...

and Welcome

Edited July 10, 2009 by Piyush

[lentilbake]

Just a quick note to say thanks again for pointing me in the right direction, managed to do exactly what I wanted in the end by following the help file and the advice in this forum. Very impressed with AutoIt!