Can a macro that reads excel and attachmate be made?

[Kuljack]

Here's what I want it to do:

Read an account number from an excel attachmate, or enter the loans I want it to run - not sure the best method..

It will send the keys to my desired screen, tab and enter the account number. Then review a specific field to read that date, and populate the same date in another specific field (this field is not always in the same spot though).

Then it would grab the next account number from the excel once complete and repeat this cycle.

The challenges:

I have six different clients of attachmate i have to sign into for the loans, so I would need to run it in one client and read all the account numbers that match this client. Macro completes, sign on another client and run again for the next set of loans for that client - and so fort.s If I had the option to tell the macro which tab to review and pull account numbers from that would be awesome.

The first step code in the screen will generally always be in the same spot, but may change. Can I determine it to review the actual field of "this step code" rather than a point on the screen?

The second step code can move around all the time, so I would definitely need a way to pin it down.

Here is a shot of what I need to do:

Start:

ACT SCHED ACTUAL STE
___ 061314 061214 M44 Review this date
___ 061214 061214 H87
___ 061214 061214 M49
___ 070114 ______ M02
___ 080114 ______ M35
___ 090114 ______ M39
___ 061314 061214 L09
___ 062714 ______ L01
___ 062714 061214 L14
___ 071214 ______ V02
___ 061914 061214 L15
___ 071214 ______ M45 This is currently blank
___ 061914 ______ L22




End game:

ACT SCHED ACTUAL STEP
___ 061314 061214 M44
___ 061214 061214 H87
___ 061214 061214 M49
___ 070114 ______ M02
___ 080114 ______ M35
___ 090114 ______ M39
___ 061314 061214 L09
___ 062714 ______ L01
___ 062714 061214 L14
___ 071214 ______ V02
___ 061914 061214 L15
___ 071214 061214 M45 It now populates this field with the M44 step date
___ 061914 ______ L22

I hope this makes sense, the concept is a mess in my head at the moment. Thanks!

 

[SkipVought]

Hi,

My advice if you're doing anything in Excel, then code in Excel VBA. It is a cadillac versus a Yugo for Attachmate VB.

Your specifications are scant. Do your screens have multiple pages? If so what are the MESSAGES for MORE and NO MORE? What is the message for a sucrssful transaction? You will first need to design you page handling logic before proceeding. How many different transactions will you need to handle. What is the screen structure for each different transaction, for the data you must manipulate?

Thats what we need to know just to start.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[remy988]

Kukjack, what does this mean?

six different clients of attachmate

i agree with Skip. your specifications are scant