Listing Excel files with title
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. :confused:
Andy
Re: Listing Excel files with title
Give me a few.. working on it for you
1 Attachment(s)
Re: Listing Excel files with title
Here you go:
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
Re: Listing Excel files with title
Thank you very much, you are a star,
this has saved a lot of tedious typing!
Re: Listing Excel files with title
no problem ;) that was an easy one