In an Excel spreadsheet I have a list of other Excel files thus:
e:\data\file01.xls
d:\workspace\invoices\invoice01.xls
c:\sales\inventory\list03\take100.xls
and so on. New addresses are added daily. The data wanted from the files is always in named ranges.
How do I go to the files by reading down the list and get the data?
Any help appreciated
Bookmarks