Open all files in a directory
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 |
Open all files in a directory
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 |
All times are GMT +1. The time now is 10:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com