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

--
HTH

-------

Bob Phillips
... looking out across Poole Harbour to the Purbecks


"Tom Waters" wrote in message
...
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