UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Drag And Drop Into Excel Cell And Creat Hyperlink To File, Any Version    
 
   
KathCobb
post Mar 26 2020, 02:37 PM
Post#1



Posts: 535
Joined: 18-October 06



I am not sure how I did this once and cannot repeat it, but in Excel 2019 I was able to set my cell property to "hyperlink" and then drag a file from windows explorer into that cell and it created a hyperlink automatically to that file location. Now I cannot get it to repeat that action to save my life. Now every time I drag something, it just tries to open the file or inserts a picture if its that type of file. Does anyone know a way to drag and drop a file into a cell to hyperlink it?

I'd appreciate any help.

Thank you
Kathy

--------------------
I know the basics, which is probably just enough to be dangerous...
Go to the top of the page
 
ADezii
post Mar 27 2020, 06:17 PM
Post#2



Posts: 3,087
Joined: 4-February 07
From: USA, Florida, Delray Beach


I'm not sure how to do it with Windows Explorer, but you definitely can Open the Office File Dialog, select a Single or Multiple Files, and programmatically Insert Hyperlink(s) to these Files in any Worksheet.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    6th July 2020 - 05:56 PM