Good Afternoon,
I am trying to create shortcut of some folders tabulated in excel sheet. I would like to create the shortcut of these folders to category wise. For instance, Folder EA-001 belongs to "Engineering" category and I want to create a shortcut of "Folder EA-001" which is available in the same directory to "Engineering Folder".
I have attached an excel file which might be helpful.
If you can help me with this one would be much appreciated.
Thanks.
Mashiul A.
on the folder column
use insert > hyperlink
Use Existing file or web page
In Address put in the full link to the folder (it will start "c:\user 1\My Documents ... or something like that)
if in doubt find the folder and set up a shortcut to it (right click>create shortcut) and then right click on the shortcut and under properties>target it will give you the exact file address of the file or folder
I have used it on your spreadsheet and it works fine on my machine (I am on 2013 - other versions may be slightly different but not by much, I also have 2007 and 2003 and it works on them)
Last edited by Graham Griggs; 02-01-2016 at 08:02 PM.
Hi Graham,
Thanks for your reply.
The method you have mentioned is usual way. I need VBA code for automate the whole process.
For simplicity I only included 3 folders but in real case I will have significant number of folders and will grow more & more.
Again, thanks for you effort.
Mashiul
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks