Opening Files Question
 

Hi All,

Background: I have a sheet with fully-qualified paths in column A. M
macro uses that path to open files and pull data across into the curren
sheet. I'm using the following code:

HL = ActiveCell.Offset(0, -32).Value & "\" & ActiveCell.Offset(0
-31).Value
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=HL, _
TextToDisplay:=ActiveCell.Offset(0, -31).Value
X = X + 1

followed by...

Do Until Hycell = ""

Selection.Hyperlinks(1).Follow NewWindow:=False
AddHistory:=True

End Loop

Question: Can I add a parameter to the Opening of each file that wil
say to NOT resolve links?

Thanks in advance for any help!

Bria

--
bkube0
-----------------------------------------------------------------------
bkube01's Profile: http://www.excelforum.com/member.php...nfo&userid=958
View this thread: http://www.excelforum.com/showthread.php?threadid=52487