Nemon Posted December 23, 2011 Share Posted December 23, 2011 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 Link to comment Share on other sites More sharing options...
Colyn1337 Posted December 23, 2011 Share Posted December 23, 2011 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 Link to comment Share on other sites More sharing options...
ChrisN Posted December 23, 2011 Share Posted December 23, 2011 Use the excel management UDF to get info from your spreadsheet (assuming you are using MS Excel) Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted December 23, 2011 Moderators Share Posted December 23, 2011 Take alook at _excelreadcell in the help file Nemon. "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum! Link to comment Share on other sites More sharing options...
Nemon Posted December 28, 2011 Author Share Posted December 28, 2011 (edited) 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 Link to comment Share on other sites More sharing options...
Zedna Posted December 28, 2011 Share Posted December 28, 2011 and then type it out in another form? For this look at ControlSetText() or ControlSend() Resources UDF ResourcesEx UDF AutoIt Forum Search Link to comment Share on other sites More sharing options...
Nemon Posted December 28, 2011 Author Share Posted December 28, 2011 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! Link to comment Share on other sites More sharing options...
Zedna Posted December 28, 2011 Share Posted December 28, 2011 Look at IE UDF in helpfile. Resources UDF ResourcesEx UDF AutoIt Forum Search Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now