Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-20-2025, 08:49 AM
Covert Codger Covert Codger is offline Microsoft Insert Hyperlink dialog sucks Windows 10 Microsoft Insert Hyperlink dialog sucks Office 2013
Novice
Microsoft Insert Hyperlink dialog sucks
 
Join Date: Jul 2022
Posts: 13
Covert Codger is on a distinguished road
Default

Thank you for your reply. I am just so used to while working in MS Word to go to the hyperlink dialog. I know about the method you suggested but never really thought about doing that. Henceforth I will try to keep it in mind for hyperlinks.
MS Excel is exceedingly easy to create hyperlinks because of the =hyperlink function which looks at the same criteria you suggested, i.e. having the name of the file and the path.


I suppose Microsucks has their seemly good reason for not having dialog boxes expandable but to my way of thinking, unless they come to their defense their position is not defensible.


In Excel I insert the file name in one cell, the path in another cell, then Concatenate those two cells and finally just apply the =hyperlink function to the Concatenated cell result.
Example:
Condusiv Sales.docx H:\Downloads\Diskeeper\Diskeeper 12\Diskeeper Professional Edition\ Folder File Diskeeper12_Professional.exe (Version: 16.0.1017.0) H:\Downloads\Diskeeper\Diskeeper 12\Diskeeper Professional Edition\Condusiv Sales.docx
The Folder designated cell opens the folder, the File designated cell opens the document and the cell showing "H:\Downloads\Diskeeper\Diskeeper 12\Diskeeper Professional Edition\Condusiv Sales.docx" contains the Concatenated formula that picks up the file name and folder location. Simply picking the Folder or the File cells jumps to the intended target.
Reply With Quote
Reply

Tags
hyperlink dialog



Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Insert Hyperlink dialog sucks increase the size of the insert hyperlink dialog box mswmacroman Word 3 02-16-2017 01:44 AM
Microsoft Insert Hyperlink dialog sucks How to dismiss/avoid warning/alert dialog boxes in Microsoft.Office.Interop.Word.Document meenagrace Word VBA 3 11-07-2014 01:29 PM
Macro to open the Insert>Cover Page window /dialog box Catty Word VBA 3 02-24-2014 06:02 PM
Microsoft Insert Hyperlink dialog sucks Insert the Hyperlink and hide all sheets except clicking Hyperlink PRADEEPB270 Excel 1 02-22-2013 09:47 AM
OFFICE(Word,Excel..)-crash/close when DIALOG BOX launched of insert image,open file buggingme Office 1 05-30-2010 12:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft