MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Starting simple


Posted by Randy B on November 12, 2001 6:46 AM

I have a list of hyper links.
I wish to open one of these files with a macro.
How would I go about this?

P.S. They are autocad files.


Posted by faster on November 12, 2001 10:10 AM

Sub FollowLink()
'this might work
'set A1 = to the cell that contains the link

Range("B1").Hyperlinks(1).Follow _
NewWindow:=False, _
AddHistory:=True
End Sub

Posted by faster on November 12, 2001 10:20 AM

Range("B1").Hyperlinks(1).Follow _ NewWindow:=False, _ AddHistory:=True

Sorry should read; set B1 to the cell that contains the link

Posted by RANDY B on November 12, 2001 12:23 PM

Range("B1").Hyperlinks(1).Follow _ NewWindow:=False, _ AddHistory:=True

OK...That works, but it does not open the file.

Posted by faster on November 14, 2001 6:37 AM

Range("B1").Hyperlinks(1).Follow _ NewWindow:=False, _ AddHistory:=True

The link if followed, but the file doesn't open?