Sign in to follow this  
Followers 0
wutangah

Data Entry Application

8 posts in this topic

#1 ·  Posted (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 by wutangah

Share this post


Link to post
Share on other sites



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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

60+ array(s)? wow!

you may need to clean those up afterwards..

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

#8 ·  Posted (edited)

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 by weaponx

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0