+ Reply to Thread
Results 1 to 7 of 7

Connecting to Bluezone v7.1 with VBA

  1. #1
    Registered User
    Join Date
    02-12-2013
    Location
    usa
    MS-Off Ver
    Excel 2003=7
    Posts
    13

    Connecting to Bluezone v7.1 with VBA

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

    Please Login or Register  to view this content.
    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:
    Please Login or Register  to view this content.
    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?

    I also ask this question in another forum mrexcel & vba express just in case someone is there that isn't in this forum.
    https://www.mrexcel.com/forum/genera...ml#post5195250
    http://www.vbaexpress.com/forum/show...-and-Excel-VBA

    Note: I missed the part about cross posting in the rules. So my appologies for not posting the links. I haven't used these forums in years as I normally have figured out my questions via google and other sources, but this one stumped me. I also didn't realize that the moderators strolled across mult forums.
    Last edited by temexcel; 12-19-2018 at 07:27 PM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Connecting to Bluezone v7.1 with VBA

    Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html

    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    02-12-2013
    Location
    usa
    MS-Off Ver
    Excel 2003=7
    Posts
    13

    Re: Connecting to Bluezone v7.1 with VBA

    Thank you for the info.

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Connecting to Bluezone v7.1 with VBA

    Hello temexcel,

    You also posted this question at VBA Express HERE

    Both VBA Express and our forum have a rule about posting a question in more than place. This is known as cross-posting. While it is not illegal to do so, we do ask that if you do it to provide a link to one of the other sites.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  5. #5
    Registered User
    Join Date
    02-12-2013
    Location
    usa
    MS-Off Ver
    Excel 2003=7
    Posts
    13

    Re: Connecting to Bluezone v7.1 with VBA

    Confused.... They are 2 different sites, so why would it matter if it posted in in two diff sites since people may be in one site but not another?

  6. #6
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Connecting to Bluezone v7.1 with VBA

    Hello temexcel,

    If your question is answered at another site like VBA Express and people here at the Excel Forum are working on a solution also, how will they know if your problem has been solved? The people at the other sites are not going to be happy that their time and effort was spent for nothing.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Connecting to Bluezone v7.1 with VBA

    Temexcel - this has also been posted on Mr Excel. I had hoped, after beiing advised about our rules when I posted earlier, that you might have read them. Had you done so, you would know about our cross-posting rule, which is the same, by the way, on practically all forums.

    Before posting again to this forum, please do read our rules. They are very simple, and all members must abide by them. Thank you for your cooperation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Runtime error 429 when trying to create Bluezone object
    By moodybob in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-05-2016, 11:59 AM
  2. Replies: 8
    Last Post: 01-16-2015, 07:21 AM
  3. Connecting with SQL through VBA
    By excelhelp20817 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-15-2014, 10:04 PM
  4. Connecting to TFS
    By Osiris00001 in forum Excel General
    Replies: 1
    Last Post: 07-17-2012, 05:19 AM
  5. VBA for connecting to C++
    By Carnifex930 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-01-2011, 03:14 PM
  6. Connecting to MS Access via VBA
    By dwijraj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2007, 02:31 AM
  7. [SOLVED] Connecting to FTP
    By ben in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-20-2006, 12:15 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1