I have an empty excel workbook open & a folder (with excel, word, pdf documents in it).
I want to be able to drag and drop the documents from the folder into my excel workbook and have a hyperlink created. Is this possible?? It would save me a TONNE of time!!
Last edited by Xx7; 02-12-2011 at 07:10 PM.
Hello Xx7,
Dragging and dropping a document from a folder into an open Excel workbook will not create a hyperlink to the document in the workbook. You would need a macro.
P.S. Would you please update your profile location from here to Vancouver, British Columbia or B.C. Canada. It helps others to know what time zone you are in. when answering your posts.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Found this add-in... it does a good job:
http://www.cpearson.com/excel/FolderTree.aspx
RE: location changed!
Hello Xx7,
Thanks for updating your location and posting the link. Does this solve your problem?
Done .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks