Noob needs guidance

[Nemon]

I am new to Autoit and I have been ok at making it do VERY VERY basic things. I'm wondering if it is possible to pull data from a field on a spreadsheet A and then type it out in another form? If you just bait me with the right commands I don't mind digging and learning.

Thanks a ton!

Nem

[Colyn1337]

Use FileWriteLine() to write to a file (you may need to use FileOpen() first).

Use FileRead() or FileReadLine() or even _FileReadToArray for reading the file and manipulating contents...

That should get you started..... If you need more help, be sure to ask

[ChrisN]

Use the excel management UDF to get info from your spreadsheet (assuming you are using MS Excel)

[JLogan3o13]

Take alook at _excelreadcell in the help file Nemon.

[Nemon]

Thanks I'll do all of the above and let you know how it turns out! Thanks much everyone!

Edited December 28, 2011 by Nemon

[Zedna]

and then type it out in another form?

For this look at ControlSetText() or ControlSend()

[Nemon]

Well I guess I’ll be more specific on what I’m doing.

I want to pull data from a cell in a web based access spreadsheet in one window and have auto it type it out in another web based form. I was doing it with simple winactivate, send and mouseclick commands. But one of the new areas I want to use does not let you paste info into it. You have to type out things in the box, so that is the problem.

I am still going to look into the suggestions you all have made, but I don’t think the excel one will work, this is just an assumption from looking at the help file on it.

I really enjoy learning this and thanks for the help!

[Zedna]

Look at IE UDF in helpfile.