Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Host Session Emulation
Hello all,
I was wondering if anyone has experience with the BlueZone terminal emulation program. Some companies have made the switch from Extra! to BZ. Anyway, I have a question as to how the OpenSession command works in an Excel macro (or is supposed to work). And here's my problem... After I've established the host object with: Set Host = CreateObject("BZWhll.Whllobj") I then am working with up to FOUR different sessions at the company I work for. We'll call these sessions A, B, X, and Y. Typically though, only two of these four are open at any one time. Should the user not have ANY sessions open when the macro runs, the following commands then open new session windows and name them accordingly: Host.OpenSession 0, 1, "ASESSION", 30, 1 Host.OpenSession 0, 2, "BSESSION", 30, 1 Where the variables above are Host.OpenSession [SessionTypeVal], [SessionIdentifierVal], ["ConfigFileStr"], [TimeoutVal], [WaitPaintsVal] SessionTypeVal - 0 - Mainframe; 1 - iSeries SessionIdentifierVal - 1 for S1, 2 for S2, 3 for S3, ... , 99 for S99. ConfigFileStr - Name of the BlueZone Configuration File. TimeoutVal - Number of seconds before returning with error. WaitPaintsVal - Number of screen paints before proceeding with script. However, the problem comes in where perhaps someone ALREADY has the sessions open on their desktop that are something else. I.E., someone clicked on XSESSION and that got assigned to (S1), and then clicked on YSESSION next which got assigned to (S2). Even though in the command I specified I wanted to OpenSession 0, 1, "ASESSION", when the macro runs, it brings up the Session 1 (S1) window (which in this senario is XSESSION), and STOPS mid string, without continuing to the "ASESSION" part to rename the window. I so I guess my question is this... is there a way to tell what sessions are currently open (if any), and if there are any open, what the names of them are and what session number they are currently assigned to? That way I can tell if Session 1 (S1) is what's it's supposed to be, etc, etc. OR, regardless of what Session numbers are open (S1, S2, S99), is there a way to tell if the name is already assigned to one of those, so the macro doesn't try and open a new window. Because if it does, an error comes up that the LU / Pool Name it's trying to connect to is already in use by another sesssion, bla bla bla. Something maybe like (and don't laugh at this coding): For All.Open.Sessions If Session.Name = "DESIREDSESSION" Then SessNum = Session.Number Else OpenSession 0, 1, "DESIREDSESSION", 30, 1 End If Next Session |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Startup and template locations in Citrix TS session and local session | Setting up and Configuration of Excel | |||
Hide Excel session when running at the batch mode | Excel Discussion (Misc queries) | |||
Retrieve data from separate Excel session | Charts and Charting in Excel | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Can't alt-tab between Excel workbooks in one session. Help! | Excel Discussion (Misc queries) |