×
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

Converting a TSYS report into an Excel file

Converting a TSYS report into an Excel file

Converting a TSYS report into an Excel file

(OP)
I need to convert a TSYS report into a file that I can import into Excel in its entirety. Could a simple macro be used to convert the TSYS report into a format I could import into my Excel spreadsheet? Could someone tell me how I can do this? I'm using Attachmate Reflection Suite 2011. Thank you.

RE: Converting a TSYS report into an Excel file

hi,

Could you be a bit more specific about this report?

Is it all in one screen?

Multiple screens? If multiple, the messages related to more and no more?

Basically, getting data from a terminal emulator is primarily a function of screen control with some sort of screen capture technique followed by a write technique into Excel.

Do you have any code at all?

Have you checked the FAQs in this forum and forum99: AttachMate solutions?

Please answer each and every question posed above as completely as required.

Skip,

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

RE: Converting a TSYS report into an Excel file

(OP)
hi,

Could you be a bit more specific about this report?

[a]The report is an internal TSYS/TSA that contains both alpha and numeric values. The report is arranged with both a header and eleven columns across the page and up to forty lines of information per page.

Is it all in one screen? [b]No

Multiple screens? If multiple, the messages related to more and no more?
[c] Yes, the number of screens varies daily. The maximum number of screens is a hundred.

Basically, getting data from a terminal emulator is primarily a function of screen control with some sort of screen capture technique followed by a write technique into Excel.

Do you have any code at all? [d] No, I don't. I'm able to write simple Excel macros, but I'm at an impasse of creating the code to extract the report from TSYS in AttachMate. Could you suggest a screen capture technique as you mentioned in your reply.

Have you checked the FAQs in this forum and forum99: AttachMate solutions: AttachMate solutions? Yes, but the questions that mirror what I'm looking for are only giving part of the code or stating the already have the code which isn't listed in the thread.

RE: Converting a TSYS report into an Excel file

There is code in the FAQs.

You will need to use VB code is you have hundreds of screens' worth of data or you can sit there, hours a day, and copy

I would not waste my time writing the code in Extra Basic. It is an awful editor and and awful language. But I have a definite prejudice. Excel VBA is a much MUCH better editor and language to work with AND your data is going to end up in Excel anyhow.

You've got a huge learning curve, sonny!

Skip,

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

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