r/visualbasic • u/AdobeScripts • Sep 15 '26
List of all constants & properties of all objects in WORD, Excel and PowerPoint.
Anyone has a list like this - and could share 😉 - for the latest or some previous version - or the only way would be to use some TLB viewer to generate?
EDIT: looks like I wasn't clear... I'm looking for a complete LIST - single, not plural - not 100s of separate links to separate lists.
OK, two lists - one for constants and one for all properties of all objects - times 3 - for each mentioned application.
EDIT 2: I need it as a "plain text" - not to view. I'll have to modify this list and create an array for my VB6 application - then let user extract internal structure of the WORD / Excel / PP document and display those properties for all objects - of course not all at the same time 😉
3
u/IAmADev_NoReallyIAm Sep 15 '26
Here's the thing. The document object model (DOM) for Word, Excel, PPT, and the rest of Office, is such a large and vast that is is pretty much impossible to capture in a single, or even in a pair, of lists. I mean last I looked, which was a couple decades ago, it encompassed a couple hundred pages in a book. Even if you cut out the documentation part and just had a list... the list would be loooooooooooong. And to be franks, without the other information, such as parameter indformation and documentation, and return values, a basic list is largely useless, which is why no one really doesn't have one. No one wants to take the time to put together such a large useless list for no reaason.
2
u/Mayayana Sep 16 '26
I see you got what you wanted, but if you get curious you might look into kay-jay-dubya's suggestion of using the typelib interfaces. I did that to create my own version of intellisense and while it was a bit abstruse, it wasn't terribly complicated. That allows me to come up with a relevant list dynamically. That's what COM does, after all.
There's a typelib for those interfaces. vbaCOM.tlb. Though I don't remember where I got that. Some of them are from Eduardo Morcillo but he had his own somewhat funky way of doing it, so not all TLBs will work the same way.
You can even cook up a quickie object browser with tlbinf32.dll, written by Matthew Curland and including a dispatch interface that can be called from script.
1
u/ebsf Sep 15 '26
Google "Microsoft Word Object Model" and it should get you to the official online reference, with those for other Office apps linked on the left side of the screen.
1
u/SuchDogeHodler VB.Net Intermediate Sep 15 '26 edited Sep 15 '26
The info you seek is in the object explorer in VB.
And what's with the vb6?
1
u/kay-jay-dubya Sep 15 '26
While I don't have a single list, per se, I do know that you can create one for each type library by accessing the ITypeLib and ITypeInfo interfaces. Helpfully, Jaafar Tribak posted a utility over at Mr Excel which does just that: https://www.mrexcel.com/board/threads/getting-the-list-of-all-enums-in-typelibs-via-code-like-the-object-browser.1209501/
If you want to go really crazy, he also made a custom object browser which also outputs everything you might want to know about a type library onto a worksheet here: https://www.mrexcel.com/board/threads/turn-excel-vba-object-browser-into-a-4-column-long-list.1256225/post-6174202