Printable View
Where can you find the class names needed to pass along in the CreateObject function.
Using the Object browser does not give the required info
Eg.
Dim objTest as Object
Set objTest = CreateObject("Excel.Application")
This will work while Excel is not in the Object browser nor was it set as a reference.
How does VB knows about e.g. Excel.Application? How to get a list of all available ActiveX object available on a computer?
You can find them only if they are registered components...
You can find the classnames under Project --> References...
It gets the list from the registry. In order for you to use an ActiveX control, it has to be registered. The registration process puts the control's CLSID into the registry along w/ its classnames, etc.
That's where VB gets them.
And if registered, where to find registered automation servers? They do not (all) appear in the object browser.
you have to check off the ones you want to use in the Project References dialog.