Hi,
What I want to do is to click a file in Windows Explorer and then drag
and drop it into a cell of an opened Excel file to create a hyperlink
to this file (i.e. later on if the linked file is a PDF file and if I
click the link, it will open the file in Adobe Reader. Of course, it
does not work in the way as I thought. Instead, Excel reads the file
into a worksheet. I wonder whether anyone has an idea how to achieve
this. It is just too tedious to use Insert -> Hyperlink to create the
link if there are many files to be linked. Thanks for any suggestion.
Paul.
Bookmarks