T1A1
01-27-2016, 06:45 PM
Establishing comm link with Eicon Aviva from Excel VBA
Hi.
I am developing an application which needs to access an Eicon Aviva interface to draw information from a mainframe environment.
Ordinarily, this would pose few challenges as I could establish the link with the following code.
Dim MySession As CAvivaSession32D2
Dim MyAppWin As AppWin
Set MySession = GetObject("c:\Filepath\Session A.a3d")
Set MyAppWin = MySession.AppWin
MySession.Activate
However, the Aviva session is running under a single sign-on security setup (Novell SecureLogin) and so the actual filepath has a suffix after the executable
"C:\Program Files\Novell\SecureLogin\tlaunch.exe" /auto /e"Eicon Aviva Session A" /hB /m /pDHS-TN3270 /q /s"
and I have been unable to find a way to make VBA read and action this accordingly (produces a syntax error at compilation).
Would appreciate some advice from someone who may have encountered similar and has found an appropriate resolution.
Thanks in advance
T1A1
Hi.
I am developing an application which needs to access an Eicon Aviva interface to draw information from a mainframe environment.
Ordinarily, this would pose few challenges as I could establish the link with the following code.
Dim MySession As CAvivaSession32D2
Dim MyAppWin As AppWin
Set MySession = GetObject("c:\Filepath\Session A.a3d")
Set MyAppWin = MySession.AppWin
MySession.Activate
However, the Aviva session is running under a single sign-on security setup (Novell SecureLogin) and so the actual filepath has a suffix after the executable
"C:\Program Files\Novell\SecureLogin\tlaunch.exe" /auto /e"Eicon Aviva Session A" /hB /m /pDHS-TN3270 /q /s"
and I have been unable to find a way to make VBA read and action this accordingly (produces a syntax error at compilation).
Would appreciate some advice from someone who may have encountered similar and has found an appropriate resolution.
Thanks in advance
T1A1