Consulting

Results 1 to 3 of 3

Thread: Bluezone 7.1 and Excel VBA

  1. #1

    Bluezone 7.1 and Excel VBA

    Currently use BZ v6.1 web so the connection I use is the code to connect and interact with BZ


    Set host = CreateObject("BZWhll.WhllObj")
    h = 1   '== SET SESSION NUMBER
    '=== CHECK WHICH SESSION IS AVAILABLE ============
        host.OpenSession 0, h, "S:\BlueZone\test.zmd", 10, 1
        host.waitready 10, 100
        host.Connect Chr(a)    '== SET SESSION NAME TO CONNECT TO
        txtConnect = host.Connect
        ResultCode = host.GetSessionName()
        h = host.GetSessionId()
    End Sub
    I can interact just fine with v6.1 (send keys, read data, etc.)


    Now we are using BZ v7.1 with is more terminal emulation. There is no BZWhll dll to create an object to.


    I can open a session:
    Set WSHShell = CreateObject("Wscript.Shell")
    Filename = "C:\BlueZone\Config\ADOA24x80-XLO1.zmd"
    WSHShell.Run (Filename)

    Can't figure out how to interact with the session once it's open via VBA in excel.
    Does anyone have know what the object(s) to connect to a BZ v7.1 session?
    Last edited by Aussiebear; 04-14-2023 at 04:20 PM. Reason: Added code tags

  2. #2
    VBAX Expert Leith Ross's Avatar
    Joined
    Oct 2012
    Location
    San Francisco, California
    Posts
    552
    Location
    Hello primeduckey,

    Have you tried contacting Bluezone directly by phone or email?
    Sincerely,
    Leith Ross

    "1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG"

  3. #3
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    Cross-posted at:
    https://www.mrexcel.com/forum/genera...-v7-1-vba.html
    https://www.excelforum.com/excel-pro...-with-vba.html


    Please read VBA Express' policy on Cross-Posting in item 3 of the rules: http://www.vbaexpress.com/forum/faq...._new_faq_item3

    Kindly also provide links to any other cross-posts on this topic.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •