B
bkube01
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
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