Hello everyone,

I searched this forum for a list of objects that can be created using the CreateObject function.

I have also searched online and on the Microsoft development site but what I am noticing is that there is not a lot of information out there.

So here is my question using the CreateObject function what all can you create? Is there a list of the objects that can be created?

The only ones that I know of so far are below:
Now these are just basic ones I know there are filesystem ones out there as well as httprequests but what I am looking for is a list of all the objects that can be created or at least the major ones. I notice that even though the above objects seem to follow a simple syntax you cannot simply create a notepad object like so
Maybe thats because VBA cannot communicate with Notepad.



Anybody know of more of the major CreateObjects or a list of them? That would be awesome to add to my library.

Thanks for your help.

The list of objects that created depends on what applications other than the one you're using are installed on the system that can exchange data with the one you're working with. Hence, there can never be a definitive list.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Ok that makes sense but what are some of the other ones you know. I know there is FileSystemObject and others. What are the most popular ones.

Basically, it could be anything that is VBA-compliant. Some you've missed out include the following MS-Office objects:
CreateObject("Outlook.Application")
CreateObject("Access.Application")
CreateObject("MSGraph.Application")
CreateObject("Visio.Application")

Other common ones include Adobe Acrobat Pro objects:
CreateObject("AcroExch.App")
CreateObject("AcroExch.AVDoc")

Then there are others, like:
CreateObject("ADODB.Recordset")
CreateObject("ADODB.Connection")
use for database queries, and:
CreateObject("Scripting.FileSystemObject")

See also: http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks very much for the link that helps me out a ton. I would assume that any kind of Microsoft application could be a created object but this is not the case with notepad. Even though I don't see any reason to ever have a notepad object since you can just read and write directly to text files pretty easily. Basically it seems like all of the office applications, Internet Explorer, Adobe Objects (Didnt know that one) and FileSystemObjects. Anything else would be interesting to know.

Thanks again.