Open all files in a directory

[Tom Waters]

Hi,

Is it possible to write a code that will open every file in a given folder
where the names of the file vary.

Thanks

Tom

 

[Bob Phillips]

Tom,

Here is a link to a previous post of mine in Google that does this using
FileSystemObject. http://tinyurl.com/km4m

This example goes through the folder looking for Excel workbooks and opens
them