For Each Next routine

[mikeymay]

I have a number of folders and I want a procedure to open each folder in the designated path and run some code if there are any files in the folder.

I am a little stuck with what code I need to do this.


Thanks

 

[al_b_cnu]

Hi,

Here's a start point:

http://j-walk.com/ss/excel/tips/tip18.htm

 

[mikeymay]

I was under the impression that I need to use FileSystemObject in order to do what I want. Is that not the case?

 

[Norie]

You don't need to use FileSystemObject but it is one method.

And if you are using Excel 2007 which Microsoft has dropped Application.FileSearch from then it might be the best method.

There are other methods though. eg Dir

 

[mikeymay]

Which is the best method?

I am not that familiar with 'Dir' method (or FSO, hence this post!!!)

 

[Norie]

I think it's really a personal preference thing.

I always use(d) the Application.FileSearch method, but sometimes it would be a bit quirky.

That's apparently why it's not available in 2007, I think.

Both the Dir and FSO methods are quite straightforward.

To get more info on them I would suggest either a board or web search.

I know that if I do a search I can find some good resources, just don't have time to post a link or example code, sorry.

 

[mikeymay]

Have spent last hour or so looking for some resources but not found anything that has solved my problem.

If anyone knows of any links it would be appreciated if you could drop them onto this thread.


Many thanks

 

[Norie]

Are you sure you found nothing?

If I google on FileSystemObject I get over 500K hits.

And if I include VBA in the search I get over 60K hits, like this one.

 

[mikeymay]

I do get a lot of hits, but nothing specifically dealing with looping through folders in a named path.....