I have a folder with xls files in. I want to index these docs by pulling out data from specific cells within them.
I want to write a vbs file to loop through each file, extract a couple of strings and write it to a new line in a text file. (effectively creating an index).
I have done some digging and am struggling to find any info on the web (mostly because the results are all excel specific.
Can any one help, offer other suggestions on a way forward?