Open Excel files in a folder
John,
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 "John Acocella" wrote in message ... I want to retrieve the file names of excel files in a specific directory, retrieveing them one at a time through a looping routine. Is there any way to do this in Excel besides using the DIR function? I thought I read something in the Microsoft knowledge base, but I can't find it. Thanks. |
All times are GMT +1. The time now is 10:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com