Share via

All Application and their methods to be used by CreateObject

Parth Gupta 180 Reputation points
2024-06-26T07:02:21.5533333+00:00

With reference to [MS-VBAL], section 6.1.2.8.1.4 about CreateObject function, it is mentioned that the 'Class' argument has a string data value, containing the application name and class of the object to create.

After some exploration i found that you can create objects of Word, Excel, etc with their provided classes for example:

CreateObject('Word.Application')

CreateObject('Excel.Application')

...etc

Could you provide a reference or a complete list of all possible applications that offer this kind of functionality and the methods they provide.

Thanks

Office Open Specifications
Office Open Specifications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Open Specifications: Technical documents for protocols, computer languages, standards support, and data portability. The goal with Open Specifications is to help developers open new opportunities to interoperate with Windows, SQL, Office, and SharePoint.
140 questions
Accepted answer
  1. Mike Bowen 1,791 Reputation points Microsoft Employee
    2024-06-28T21:28:23.58+00:00

    Hi Parth Gupta,

    The valid objects are listed in the registry

    User's image

    Please let me know if you have any more questions.

    Michael Bowen Sr. Escalation Engineer - Microsoft Open Specifications

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.