Data Entry Application

[wutangah]

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

[weaponx]

So what is it that takes time? Do you do anything by hand?

[wutangah]

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?

[PsaltyDS]

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.

[JC1]

60+ array(s)? wow!

you may need to clean those up afterwards..

[PsaltyDS]

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.

[bluebearr]

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)

[weaponx]

My first interpretation was that you had a working program that:

1. Copied each row from Excel

2. Switched to the "Data Entry Program"

3. Populate the fields

4. Submit

5. Switch back to excel

6. Repeat

And 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