PDA

View Full Version : Bluezone 7.1 and Excel VBA



primeducky
12-19-2018, 10:18 AM
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?

Leith Ross
12-19-2018, 11:23 AM
Hello primeduckey,

Have you tried contacting Bluezone directly by phone or email?

macropod
12-19-2018, 03:40 PM
Cross-posted at:
https://www.mrexcel.com/forum/general-excel-discussion-other-questions/1081333-connecting-bluezone-v7-1-vba.html
https://www.excelforum.com/excel-programming-vba-macros/1257183-connecting-to-bluezone-v7-1-with-vba.html


Please read VBA Express' policy on Cross-Posting in item 3 of the rules: http://www.vbaexpress.com/forum/faq.php?faq=new_faq_item#faq_new_faq_item3

Kindly also provide links to any other cross-posts on this topic.