Untitled 1.jpg
In my # Liste named excel file, I have a list of people (as you see on B column) and a folder for each of them with their names.
I want this if you can help me:
When I select a cell and press macro button, I want macro to create a hyperlink to the folder in same location as in picture.
Extra:
1. In addition to macro above, is it also possible to create a folder with same name? That would save my time from creating folder with same name.
2. After a while I compress folders in rar format with same name and move to archieve folder. Is it possible something like: "if hyperlink doesn't work, go to archieve folder and hyperlink to a rar file there?"
I am an amateur macro user and wonder about the limitations of VBA by my last two additional questions. Thanks in advance..
Bookmarks