List available methods for an object

[craig.penny]

Hi all,

I have this bit of code:

Dim oExcel As Object: Set oExcel = CreateObject("Excel.Application")

Is there a way to see all of the available methods for "oExcel"?

Thank you!

 

[Andrew Poulsom]

If you use early binding you will get IntelliSense.

 

[RoryA]

Or use the Object Browser in the VBEditor (f2)

 

[craig.penny]

Thanks Andrew and RoryA! I might have finally learned something about early vs. late binding...

You guys are the bees' knees/cats' pajamas

 

[craig.penny]

I used

Dim oExcel As Excel.Application: Set oExcel = CreateObject("Excel.Application")

and intellisense worked perfectly. That one was easy to figure out how to bind early. I have a couple other variables that I don't know how to use this on.

Dim oFso As Object: Set oFso = CreateObject("Scripting.FileSystemObject")
Dim oFolder As Object: Set oFolder = oFso.getfolder("C:\Users\Craig.Penny\Desktop\ABC123")

How would I do these?

Instead of posting each specific question, could you recommend a way to learn to do this in general?

Thanks again!

 

[Andrew Poulsom]

To early bind to FSO set a reference to Microsoft Scripting Runtime.

 

[Norie]

Craig

oFso would be declared as FileSystemObject and oFolder as Folder.

You'll need a reference to Windows Scripting Runtime.

 

[craig.penny]

It didn't even occur to me that I would need to set any additional references but now it makes perfect sense.

Thanks Andrew and Norie!