program control

[Guest]

I've been using Excel and VBscript to retreive and post information to
another program (Exceed's Hummingbird) When I start the script I use to
following to allow access to Hummingingbird;

Dim HostExplorer As Object
Dim tn3470 As Object


Set HostExplorer = CreateObject("HostExplorer") ' Initialize
HostExplorer Object
Set tn3270 = HostExplorer.Hosts(0) ' Set object for current session

I use this because it's what I was told to use. My question?

How do I know that HostExplorer is the name use to define the Object?

How do I determine the right name to use for another program to define it
for an Object?

 

[kkknie]

One way is to add the program to the references Tools | References i
VBE. Then you can check by typeing Dim Obj as, and you will get a lis
of what you can declare it as. When you find the program in the list
that's the value you use.

For example, a ADO connection (referencing Microsoft ActiveX Dat
Object) would look like this:

Dim objConn As ADODB.Connection

so you would use

Set objConn = CreateObject("ADODB.Connection")

HTH

 

[Guest]

I tried your example and could see the ADODB.Connection, but I couldn't see
the one I use. Typing in Dim Obj (or ObjConn) as would not show HostExplorer
in the list (this is one I am using). Do I need a different Reference Libary
turned on?

BTW did I mention that I'm a real rookie at this, so please type slowly..

 

[kkknie]

Yes. The ADO thing was just an example (just in case you were
rookie).

Hopefully, when you go to References, you will see something related t
your Exceed Hummingbird application. Check this box and Dimming A
again.

 

[Bob Phillips]

You may have to go and find the typelibrary file in References if VBE
doesn't already know it.

 

[Guest]

This would be a DLL file somewhere in the programs directory?

 

[Bob Phillips]

It could be a dll, but could be an olb or a tlb.

And then it might be in the programs directory, or in windows, depends on
the implementation. Really you need to know these facts and search for it.