Open files from an excel list

[MOB]

Hi

I have a list of numbers in a spreadsheet;

50000
50001
50002
etc

These numbers refer to filenames in a directory S:\invoices\50000.xls etc etc

Can I get excel to look in that directory and open all of the files listed above?

 

[srburk]

Can I get excel to look in that directory and open all of the files listed

If these are files you will access often, could you save the "workspace"?

When opening the workspace, I believe it will open up the Excel documents you were working on when you saved the workspace.

 

[Zack Barresse]

Check out Ken Puls favourites addin..

http://www.excelguru.ca/node/64

HTH