Scott has attended:
The Business Game for the Government Actuary Department course
Creating hyperlink to a workbooks I currently have open
I often create hyperlinks to workbooks in other workbooks, emails and word documents. What is the fastest way to create a link to a workbook that I currently have open? I know there is a ways of doing it without going through the whole locating the route to the file through the network of folders rigmarole, but I cant figure them out.
RE: Creating hyperlink to a workbooks I currently have open
Hi Scott,
Thank you for the forum question.
What kind of hyperlinks do you need. A link to open the file or a link to a specific cell content?
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Creating hyperlink to a workbooks I currently have open
Just to open the file (I know how to link to a specific cell if need be). My point is that if I have the workbook that I want to make the link to open on the screen, how do I make the hyperlink quickly? I often use save-as and copy the file path to the current the folder and then paste that into the insert hyperlink tool to save time, but even this takes too long.
RE: Creating hyperlink to a workbooks I currently have open
Hi Scott,
I do not really know what you expect, but VBA can do it.
Please paste the code below in Excel. You will need to select the cell in which you need the hyperlink. Execute the code. You will get a file picker. Select the file and you will get the hyperlink in the selected cell.
Sub InsertHyperLink()
With Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = False
If .Show = True Then
Selection.ClearContents
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=.SelectedItems(1)
Else
MsgBox "You didn't select a file"
End If
End With
End Sub
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Creating hyperlink to a workbooks I currently have open
Thanks Jens, why I am I not surprised by your answer that "VBA can do it"? But this isn't the sort of solution I am looking for. I want to avoid the whole "file picker" rigmarole, it takes too long for me to navigate through the maze of folders within folders to the file I want to create the link to, when the file I want to pick is already open on my screen. What I really want is a fast way to get the file path to an open file. If I could add this to the ribbon at the top of excel, for example, that would save a lot of time.
RE: Creating hyperlink to a workbooks I currently have open
Hi Scott,
Sorry but I cannot find a solution with code a tool in C++. You can display the file path in the quick access tool bar if this is any help.
https://www.howtogeek.com/161002/how-to-display-the-location-of-a-file-on-the-quick-access-toolbar-in-office-2013/
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
