Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show most recent files first when opening excel files | Excel Discussion (Misc queries) | |||
Opening Quattro Pro for Windows files (*.WB1 Files) using Excel 20 | Excel Discussion (Misc queries) | |||
How can I view files chronologically when opening multiple files | Excel Discussion (Misc queries) | |||
Opening Files | Excel Programming | |||
opening files | Excel Programming |