Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Attachmate 6.71 & Excel

Status
Not open for further replies.

DarkWynd

Programmer
Nov 27, 2012
5
CA
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?
 
hi,

You have the correct file in your Tools > References.

Mine:
[tt]
Location: C:\Program Files\E!PV\extra.tlb
Language: Standard
[/tt]


Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
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?
 
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,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
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.
 
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).
 
Try this
Code:
object.DfltXfrType = rcXfrASCII

the object is probably the session object.

Anyone who tries this, please report back if it works.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top