I have a large excel spreadsheet. Within the spreadsheet are references
to word documents. These word documents are all stored in the same
folder. The only difference between what the word documents are called,
is a number, i.e. WORD123, WORD537, etc. I wish to make a link within
the excel spreadsheet to these word documents. I know I could use
hyperlinks to do this, however there are a vast quantity of links that
I wish to make and it would take too long to do it this way. If I use a
macro could I write a code to automatically find these word documents.
Any help is really appreciated. Thanks.


---
Message posted from http://www.ExcelForum.com/