That's basically what I'm doing now - except I use the keyboard shortcut
(Ctrl+K). I am not having problems getting the hyperlink into the
spreadsheet, except I have to use the whole document path and name, and it's
so long it truncates in the dialog box window, and I have to add in the
missing info every time. I have 89 more to do today.
Since I create the string I would use for this in Word when I save the doc
via Word macro, I'm wondering if there's a way I can get that string to
migrate from Word VBA to Excel VBA and use it in an Excel macro to
programmatically insert the hyperlink.
Ed
"pikus " wrote in message
...
It's very easy. From the Main Menu go to Insert--Hyperlink and the
window you need will appear. It should be pretty intuitive from there.
- Pikus
---
Message posted from http://www.ExcelForum.com/