Method not available

[vincenzo345]

Hello everyone!

Im trying to really develop some skills in VB so I may have some follow up questions as to how a bit of code works.

Right now I'm working on a project to open all workbooks in a folder (the folder will change on a daily basis and the amount of workbooks in each folder will vary too). Eventually I'll have it make certain changes in each workbook.

But for right now I have

Please Login or Register  to view this content.

One issue I have is that the ".Files" method in the For each Loop is not available. I see other similar Subs out there that utilize this method but for some reason I dont have it. Is there some other type of fileobject that will allow me to run this for each loop?

I also have the microsoft striplet library imported

[LJMetzger]

Hi vincenzo345,

You were missing a call that created the 'File System Object'. I modified your code slightly to use 'Late Binding' (not important what 'Late Binding is or does) so that you do not need the library reference:


Try:

Please Login or Register  to view this content.

For more information about 'Early Binding' and 'Late Binding' (only if you want to make your head spin) see: http://peltiertech.com/Excel/EarlyLateBinding.html
I prefer 'Late Binding' which disagrees with the Author. I like 'Late Binding' because it avoids the need for Library references, even though it may require a little more work at times when referring to Constants that are automatically provided by the Library reference.

The following items may help you in the future:
Debugger Secrets:
a. Press 'F8' to single step (goes into subroutines and functions).
b. Press SHIFT 'F8' to single step OVER subroutines and functions.
c. Press CTRL 'F8' to stop at the line where the cursor is.
d. 'Left Click' the margin to the left of a line to set (or clear) a BREAKPOINT.
e. Press CTRL 'G' to open the IMMEDIATE WINDOW. 'debug.print' statements send their
output to the IMMEDIATE WINDOW.
f. Select View > Locals to see all variables while debugging.
g. To automatically set a BREAKPOINT at a certain location put in the line:
'Debug.Assert False'
h. To conditionally set a BREAKPOINT at a certain location put in lines similar to:
if i >= 20 and xTV20 > 99.56 then
Debug.Assert False
endif
i. A variable value will be displayed by putting the cursor over the variable name.

Lewis

[Norie]

If you are using early binding and have an appropriate reference for FileSystemObject try this.

Please Login or Register  to view this content.

[vincenzo345]

LTMetzger,

Thanks for the information on early and late binding. As a habit I always use early binding. . . in fact I didn't know lat binding existed.

Norie,

Thanks for the solution. I realized what I was having issues with. The first thing was that I defined Fldrobj and Fileobj as the wrong variable type. The other issue I realized was that I was trying to use the Filesystemobject class instead of an instance of the class.


Thanks again!