I need a macro to drag and drop files into excel and create hyperlinks for them. For example, I have an invoice saved in a folder on my computer and I want to create a hyperlink to that invoice (pdf file) in excel by simply dragging and dropping the file from the folder into excel cell.
For example, please see the following video: https://www.youtube.com/watch?v=GRpbcJEdPBQ
I haven't had any luck finding the source code for this so any help will be appreciated. Thank you.
Last edited by param.malkan; 09-18-2017 at 04:40 AM.
welcome to the forum
This does the same thing the other way round and is just as quick
To test:
- download attached workbook
- open it
- double click in any cell
- browse to any file
- select file
- click on Open
- hyperlink inserted in active cell
(code currently defaults initial browsing to folder of active workbook - amend to preferred folder path)
Place this code in SHEET module
Please Login or Register to view this content.
Last edited by kev_; 09-18-2017 at 06:26 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Re: Creating hyperlinks in excel using drag and drop
welcome to the forum
This does the same thing the other way round and is just as quick
To test:
- download attached workbook
- open it
- double click in any cell
- browse to any file
- select file
- click on Open
- hyperlink inserted in active cell
(code currently defaults initial browsing to folder of active workbook - amend to preferred folder path)
Place this code in SHEET module
Thank you so much for the answer it really helped me.
How can I modify the vba code to display the file name and not the entire path?
And also I whant to limit the posibility to insert hyperlinks to a specific range("A1:A100")
Administrative Note:
Hello constantinionalex and Welcome to Excel Forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks