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?

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



--
kkkni
-----------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754
View this thread: http://www.excelforum.com/showthread.php?threadid=26548

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" wrote:


One way is to add the program to the references Tools | References in
VBE. Then you can check by typeing Dim Obj as, and you will get a list
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 Data
Object) would look like this:

Dim objConn As ADODB.Connection

so you would use

Set objConn = CreateObject("ADODB.Connection")

HTH

K


--
kkknie
------------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...fo&userid=7543
View this thread: http://www.excelforum.com/showthread...hreadid=265481

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.



--
kkkni
-----------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754
View this thread: http://www.excelforum.com/showthread.php?threadid=26548

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

--

HTH

RP

"Bill" wrote in message
...
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" wrote:


One way is to add the program to the references Tools | References in
VBE. Then you can check by typeing Dim Obj as, and you will get a list
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 Data
Object) would look like this:

Dim objConn As ADODB.Connection

so you would use

Set objConn = CreateObject("ADODB.Connection")

HTH

K


--
kkknie
------------------------------------------------------------------------
kkknie's Profile:
http://www.excelforum.com/member.php...fo&userid=7543
View this thread:
http://www.excelforum.com/showthread...hreadid=265481

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

"Bob Phillips" wrote:

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

--

HTH

RP

"Bill" wrote in message
...
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" wrote:


One way is to add the program to the references Tools | References in
VBE. Then you can check by typeing Dim Obj as, and you will get a list
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 Data
Object) would look like this:

Dim objConn As ADODB.Connection

so you would use

Set objConn = CreateObject("ADODB.Connection")

HTH

K


--
kkknie
------------------------------------------------------------------------
kkknie's Profile:
http://www.excelforum.com/member.php...fo&userid=7543
View this thread:
http://www.excelforum.com/showthread...hreadid=265481

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.

--

HTH

RP

"Bill" wrote in message
...
This would be a DLL file somewhere in the programs directory?

"Bob Phillips" wrote:

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

--

HTH

RP

"Bill" wrote in message
...
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" wrote:


One way is to add the program to the references Tools | References
in
VBE. Then you can check by typeing Dim Obj as, and you will get a
list
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 Data
Object) would look like this:

Dim objConn As ADODB.Connection

so you would use

Set objConn = CreateObject("ADODB.Connection")

HTH

K


--
kkknie

------------------------------------------------------------------------
kkknie's Profile:
http://www.excelforum.com/member.php...fo&userid=7543
View this thread:
http://www.excelforum.com/showthread...hreadid=265481