Hi,
I tried that but the macro stops at your line and highlights the word 'target'
Thanks for your help. Also some drawings have more than 1 sheet, can the
code be tweaked to get all the drawings and put them in H2, H3, H4 and so on?

Regards

paul

"BizMark" wrote:


I believe the line you are looking for to insert after:

WS.Range("H2").Value = WS.Range("H2").Value & " " & MyFileName

is:

WS.Hyperlinks.Add anchor:=WS.Range("H2"), target:= MyFileName

Regards,
Mark




--
BizMark