Creating Objects

**blane245** · 01-14-2010, 01:47 PM

I've been using the Scripting.FileSystemObject class for sometime a bit blindly and have notices that there are several other classes available (e.g. InternetExplorer.Application), but Excel 2003 does not do a good job of allowing Object browsing or providing help documentation on these classes. Can someone give me a pointer to the various classes that are accessible to VBA so I don't have to poke around so much?

**shg** · 01-14-2010, 01:55 PM

If you set a reference in the VBE to the library of interest (Microsoft Scripting Runtime in the case of the FileSystemObjecty object), then you can look at an object's properties and methods in the Object Browser.

**Paul** · 01-14-2010, 01:56 PM

Hi Blane,

A good start, while it's a lot of information, is here at MSDN:

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

This is the Excel 2003 VBA Language Reference site. You can expand the tree on the left to show the References to Collections, Objects, Methods, etc. It can be quite daunting, and not always the easiest to find things if you're not sure of what you're looking for, but it can provide a wealth of information.

**blane245** · 01-14-2010, 02:08 PM

shg, Thanx. I thought it was something like that, though I can't seem to find the type library for Internet Explorer. How do they relate CreateObject("Scripting.FileSystemObject") to the type library that you called out? Is there any documentation on this type library

Paul, I've already got my hands around the classes on Excel VBA. What I need is to get my hands around those type libraries that I can reference.

**shg** · 01-14-2010, 02:52 PM

the type library for Internet Explorer

http://vba-corner.livejournal.com/4623.html?

**blane245** · 01-14-2010, 06:49 PM

go figure. Where do people get these things? Hip pocket, huh? Google? msdn? Stiil want to know how VBA translates "InternetExplorer.Application" into "Microsoft Internet Controls"