What's the best way to find an appname for VBA?

[gadavi1]

First time poster, and relative newbie to VBA. I want to follow the forum rules, so let me know if I do something out-of-line and I'll try not to do it in the future.

The other day, I figured out how to automate another program from EXCEL using the following line of code:

Set sys = Create.object("Accmgr.System")

But I was only able to figure this out by sheer luck. Somebody who uses the same program posted a VBA question online, and I was able to figure out that "Accmgr.system" was the appname that I wanted to use to automate this particular program.

There are other programs that I would like to automate with VBA in EXCEL, but I don't know their appnames. What's the easiest way to figure out the appname of a program? Is there perhaps a list that I can look up in the object browser?

Thanks!

 

[chuckles1066]

That would be interesting to know.

By perusing code posted here, I know that

Set db = CreateObject("Access.Application")

enables Access and

Set outapp = CreateObject("Outlook.Application")

enable email via VBA

 

[xenou]

Probably you could use the object browser (F2 in the Visual Basic Editor). For instance, you'll find you have a library called Excel and it has an object called Application ... ergo, CreateObject("Excel.Application"). You can browse the references (Tools | References) to set references to more objects (but there's probably hundreds available, 99% of which you'll never directly interact with in VBA). In practice, I just google the keywords CreateObject and what I'm interested in and usually I find it - a select few items that I automate on a regular basis and a very few others that I use infrequently.

 

[Jaafar Tribak]

Or you could use the Registry editor. Select the HKEY_CLASSES_ROOT key Press Ctrl+F and type in ProgID , keep on pressing F3 until you find the ProgID and Class name of your target application.