Cycling through files in a folder

[RichyT]

I want to cycle through all files in a folder, opening each one (preferably individually) and then working on them. Is there any way of using a file system object method to do this, or an alternative method?

Cheers

Rich

 

[xlbo]

See thread707-342727 for 2 ways of looping through a folder and picking up the filenames
Swap the entering filename on sheet for :
workbooks(filename).open

ps - by "then working on them" do you mean thru code or manually. If you want to work on them manually, I don't think it's possible 'cos you'd have to interupt the code.... Rgds
~Geoff~