I want to be able to store a list of infividual Excel workbooks in a column in a master workbook. I want to be able to open each of these workbooks in turn, via a macro, and extract data from them. Can I store the individual workbook name as a variable and pass it to the open.workbook command?? If so, what is the proper syntax, or where can I find it?
Thanx
