wutangah Posted August 16, 2007 Share Posted August 16, 2007 (edited) Hello AutoIT Community! For quite sometime now, I have been using an AutoIT macro that uses these components: 1)An open excel spreadsheet 2)Proprietary Data Entry Software The macro copies the values into memory from excel then switches to the data entry program and pastes the data for entry. There are times where there maybe 30 to 60+ entries on the excel spreadsheet and switching back and forth between the two programs is time consuming. What do I do to streamline this process? Edited August 16, 2007 by wutangah Link to comment Share on other sites More sharing options...
weaponx Posted August 16, 2007 Share Posted August 16, 2007 So what is it that takes time? Do you do anything by hand? Link to comment Share on other sites More sharing options...
wutangah Posted August 16, 2007 Author Share Posted August 16, 2007 So what is it that takes time? Do you do anything by hand?>>So what is it that takes time?Copying and pasting from excel to the data entry program.>>Do you do anything by hand?Mixing my coffee, driving my car and some unmentionables with my spouse.In essence, is there anyway to load all the data into memory so that there is no more switching back and forth to and from excel? Link to comment Share on other sites More sharing options...
PsaltyDS Posted August 16, 2007 Share Posted August 16, 2007 Pull all the data you need from Excel into an array, then switch to the other program and just step through the array for inputs. No need for going back-and-forth. Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Link to comment Share on other sites More sharing options...
JC1 Posted August 16, 2007 Share Posted August 16, 2007 60+ array(s)? wow! you may need to clean those up afterwards.. Link to comment Share on other sites More sharing options...
PsaltyDS Posted August 16, 2007 Share Posted August 16, 2007 60+ array(s)? wow!you may need to clean those up afterwards..There is nothing astounding at all about 60 arrays (or a single array of 60 arrays, or single array with thousands of elements).You are too easily impressed. AutoIt can handle it easily. How many elements do you pull from each of these (60?) Excel spreadsheets? Unless it's like tens of thousands per sheet, AutoIt won't even break a sweat. Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Link to comment Share on other sites More sharing options...
bluebearr Posted August 16, 2007 Share Posted August 16, 2007 Hey, this is fun: here's a little COM to get the used range from the currently active spreadsheet into an AutoIt array (and then display it). #include <Array.au3> Const $iShowAll = 1, $iTranspose = 1 $oExcel = ObjGet("", "Excel.Application") $oActiveRange = $oExcel.ActiveSheet.UsedRange $aValues = $oActiveRange.Value _ArrayDisplay ($aValues, "Values", $iShowAll, $iTranspose) BlueBearrOddly enough, this is what I do for fun. Link to comment Share on other sites More sharing options...
weaponx Posted August 16, 2007 Share Posted August 16, 2007 (edited) My first interpretation was that you had a working program that:1. Copied each row from Excel2. Switched to the "Data Entry Program"3. Populate the fields4. Submit5. Switch back to excel6. RepeatAnd it just wasn't working fast enough.The macro copies the values into memory from excel then switches to the data entry program and pastes the data for entry. Edited August 16, 2007 by weaponx 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