Read spreadsheets on a list

My program is going to process thousands of spreadsheet while I listed these files in a seperate spreadsheet. How can I read the list of the spreadsheet then let the program process them? Like, the spreadsheet name list is'FundsName.xlsx' [num, txt, raw] = xlsread('FundsName.xlsx');

This is reading this spreadsheet. How could my program process the spreadsheet listed in this one. What should I do next?

Many many thanks!

Daisy

Answer 1

[Image Analyst]

Use xlsread to get the names from the FundsName workbook. Then open Excel using ActiveX. Then get xlswrite1 from the File Exchange. Use a for loop like in the FAQ to loop over each file, opening it via ActiveX, doing your stuff, and then (if necessary) sticking stuff back into the workbook with xlswrite1(), saving it, and closing it before continuing in the loop to process additional files. Search for ActiveX and Excel and you should find examples.