Open all files in a directory

  • Thread starter Thread starter Tom Waters
  • Start date Start date
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
 
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
 
Back
Top