If I set openfiledialog to allow multiple file names, and open multiple
excel
files, when I do a 'For each filename . . . ' and read a set range for
each
worksheet, I only get data from the last excel worksheet in the list -
even
if I close my excel.application and create a new instance from within the
iteration.
I want to open multiple spreadsheets, extract a range of data from each,
and
bring that data into an XML file. All works fine with a single
Spreadsheet.
Thanks
