×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Can a macro that reads excel and attachmate be made?

Can a macro that reads excel and attachmate be made?

Can a macro that reads excel and attachmate be made?

(OP)
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!

RE: Can a macro that reads excel and attachmate be made?

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Can a macro that reads excel and attachmate be made?

Kukjack, what does this mean?

Quote:

six different clients of attachmate

i agree with Skip. your specifications are scant

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close