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?
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?