I would first try to see if you can find the prog id in the Registry. From
the Windows Start menu, choose Run and enter RegEdit. In RegEdit, open the
HKEY_CLASSES_ROOT section and find the ProgID, something along the lines of
"HostExplorer.Application". If you find the right key in the registry, use
that key in your CreateObject statement.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




"Dustin H" <Dustin wrote in message
...
I am using a older version of Hostexplorer and am trying to control it from
excel so that automate some of my tasks. I basicly need to open a vt
session
send some commands to get the report pulled then copy the screen and past
it
into excel. I have tried. The generic example below and i get a Run-time
error '429':
ActiveX component can't create object. ANy help would be greatly
appreciated.

Sub main()
Dim HostExplorer as Object
Set HostExplorer = CreateObject("HostExplorer")
End Sub