Maybe...

ActiveWorkbook.FollowHyperlink _
Address:="file:////" & "D:\Downloads\HP ProLiant Spare parts\" & .Value

(Watch the folder name--I wasn't sure about the spaces.)

grahammal wrote:

Have modified the
ActiveWorkbook.FollowHyperlink Address:=.Value
line to read
ActiveWorkbook.FollowHyperlink Address:="D:\Downloads\HP ProLiant Spare
parts\" & .Value
This is where all the Word Docs are.
Still no joy.
Do I need to add a '.doc' extention to it perhaps, if so, how?

--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=537163

--

Dave Peterson