Error: Method or Data Member Not Found

I am trying to run the following code from https://msdn.microsoft.com/en-us/lib...(v=vs.85).aspx
However, when I try to run it, I get a message saying "Compile Error: Method or Data Member not Found"

I have added the Microsoft Internet Tools and Microsoft Shell Control and Automation references to my workbook, like the site said. Any help with this would be appreciated.

Please Login or Register  to view this content.

Well, as Murphy's law would have it, I have discovered the answer immediately after posting. Changing "Dim objFolder As Folder" to "Dim objFolder As Folder2" fixed it.

Hello k64,

You need to be careful with the Shell and typing the variables. You need to define constant values as Constants whether they are strings or numbers.

This works...

Please Login or Register  to view this content.

Thank you Leith, was it the constants that were causing the issue, or the early binding of the objects?

Hello k64,

Working with the Shell can be a bit finicky. The Namespace property is usually where people get tripped up. It will only accept constant values or a variant data type.

Examples:

Please Login or Register  to view this content.

Also, I generally don't make a habit of loading libraries in my code since most of what I do is redistributed. Keeping objects generic avoids the pitfall of declaring an object as the wrong class. Early binding is nice because of the intellisense. As you discovered with FolderItems2 and FolderItems3. FolderItems3 is returned only for items of a folder as a collection and as individual items.

Thank you Leith Ross,

That's good info to have. So, do you just dim all objects as Object and then set = CreateObject? I'm still a bit confused about folderItems, FolderItems2, and FolderItems3. If you have a Folder and take its Items property, how do you know which of those it will be?

Hello k64,

Generally, I dimension my objects using the generic object type Object because you don't have to know ahead of time which object type you are dealing with (late binding). As you have found out using early binding with Shell can be problematic.

You can easily discover the object type in VBA by using the TypeName function. This works for objects and all other variable types.

Examples

Please Login or Register  to view this content.

Once you know the object type, you can then use the object browser in VBA to look at the properties, methods, and other objects associated with the variable type.

Thank you Leith Ross. I never knew about the TypeName function. That will help a lot!