×
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

Attachmate 6.71 & Excel

Attachmate 6.71 & Excel

Attachmate 6.71 & Excel

(OP)
I'm having problems using Excel to gather data from Attachmate Extra 6.71.

First of all, I'm trying to select the appropriate object library in Excel -> VB Editor -> Tools -> References. Initially, I could not find any Object library in the list, so I browsed on the Hard-Drive to see if I could locate it somehow. I found the following file : "C:\Program Files\E!PC\Extra.tlb". However, when I load this file, it is displayed in spanish or italian : "Biblioteca de objetos do Extra! 6.5 da Attachmate"

This should not be causing a problem, however, when I run my macro and then use the function "GETSTRING" to get a specific string on screen (Which I read as "JCLEDIT"), Excel reads it as : "ÑÃÓÅÄÉã". Therefore causing me to get Junk data in my spreadsheet.

Anybody knows anything about this issue?

RE: Attachmate 6.71 & Excel

hi,

You have the correct file in your Tools > References.

Mine:

Location: C:\Program Files\E!PV\extra.tlb
Language: Standard

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Attachmate 6.71 & Excel

(OP)
Thank you for the clarification.

That doesn't however solve the problem with the "GETSTRING" Function that I'm having though... If I'm using the correct object library, why is GETSTRING reading junk data from the screen?

RE: Attachmate 6.71 & Excel

Seems you may have a different language setting somewhere in your setup.

Have to also checked the font and character set being used on the sheet.

THIS would greatly disturb me, "when I load this file, it is displayed in spanish or italian : 'Biblioteca de objetos do Extra! 6.5 da Attachmate'" when you should see Attachmate Extra! x.y Object Library.

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Attachmate 6.71 & Excel

(OP)
Here are my Language settings I see :

OS : Windows XP 5.1 (SP3)

Control-Pannel -> Regional & Language Settings :
Standards & Format : English (Canada)
Location : Canada
Text Services & Input Languages :
Default Input Language : French (Canada)
Installed Services :
- Chinese (PRC) - Ink Correction
- Chinese (Taiwan) - Ink Correction
- French (Canada) - Ink Correction & Keyboard (Canadian French)
- Japanese - Ink Correction
- Korean - Ink Correction
Language for non-Unicode Program : English Canada

MS Excel : 2010 v14.0.6106.5005 (32 bit)

File -> Options -> Language
Editting languages:
- English Canada <default> - Keyboard Layout: Not Enabled - Proofing: Installed
- French Canada (by policy) - Keyboard Layout: Enabled - Proofing: Installed
Display Language: Match MS Windows
Help Language: Match Display Language
Tooltip Language: Match Display Language
Font used : Calibri

Attachmate Extra v6.71

Options -> Settings -> Display -> Host Code Page
Canadian Bilingual (037)

-------

I honestly do not know where this Spanish is coming from and why the GETSTRING function is getting junk data.

RE: Attachmate 6.71 & Excel

You are receiving an ASCII translation of the EBCDIC Characters on the screen.

Here's the same data you see on your screen, that I have cut and pasted from a mainframe file with DISPLAY HEX ON, so that the two lines underneath show the upper and lower byte of the character's hex value:

CODE

JCLEDIT
DCDCCCE
1335493 

So, the character J in EBCDIC is X'D1'.

Here's the unicode values from Microsoft Word insert symbol dialog box for the latin-1 characters you are seeing:

CODE

Ñ  X’00D1’  which in EBCDIC is J
à  X’00C3’  which in EBCDIC is C
Ó  X’00D3’  which in EBCDIC is L 
and so on. That's your problem.

I know there is a setting for that translation on the FTP options, but I don't know what you need to do to tell excel to tell attachmate to scrape the screen as if it were ASCII. It's probably a simple one-line command to the session object.

Worst case scenario, you can built a translation table (cough, cough).

RE: Attachmate 6.71 & Excel

Try this

CODE

object.DfltXfrType = rcXfrASCII 

the object is probably the session object.

Anyone who tries this, please report back if it works.

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