Archive of Mr Excel Message Board

Back to Hyperlinks in Excel archive index
Back to archive home

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.

Re: Starting simple

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

Re: Starting simple

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

Re: Starting simple

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.

Re: Starting simple

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?

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.