| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to insert a hyperlink to external file
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink stored in an external workbook | Excel Discussion (Misc queries) | |||
| Creating Macro to insert a hyperlink and then sort ... | Excel Discussion (Misc queries) | |||
| External hyperlink to a specific page in a workbook | Excel Worksheet Functions | |||
| Insert date modified of external file | Excel Discussion (Misc queries) | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Hybrid Mode
