I am trying to list the filenames of a directory containing aprox 2000 spreadsheets. This part is not so difficult, but as I go through I want to pull out a title from each spreadsheet, held in cell B1 and place this in a file along with the filenames.
At the moment I have the following code as a java script but would like to know how to extract data from inside each of the files whilst iterating as well.
Put this file in your XLStart folder (if you want it to be there all the time) (Or just load it into excel for 1 time use...)
At the top, to the right of your menu (Help option) will be a new button.
click it, you will be asked to choose a directory...
pick the directory....
when you click ok.. a new workbook is added.. then
the code opens each workbook in turn, puts the full path in Col A and the title from B1 into column B
might take a while to do 2000 but I just ran it for 30 and it seemed to work fine
JPnyc rocks!! (Just ask him!)
If u have your answer please go to the thread tools and click "Mark Thread Resolved"
Listing Excel files with title
Reply With Quote
that was an easy one
