Open all files in a directory

T

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
 
B

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
 
Top