Open Folder: Folder Name In Cell

  • Hello,


    After searching for an answer (even a 'related' one) and never found one, I' ve decided to "cry for help".


    I want to make a macro able to pick up the name of the folder present in a cell (2 cells left from where the image associated to that macro is) and open the correspondent folder.


    EX:


    I have the following folders:
    C:\myfolders\folder1
    C:\myfolders\folder2
    C:\myfolders\folder3


    The cells containing the folder name are E1, E2, E3 ... and the values inside are folder1, folder2, folder3 ...
    In the G column - G1, G2, G3 ... I have a macro icon on each cell.


    I would like to have 1 macro to be able to do this (I was thinking to make a separate macro for each cell :rolleyes: but ... I imagined it should be a easier way)


    Thank you very much for any reply!

  • Re: Open Folder: Folder Name In Cell


    Thank you for suggestion - I've tried the hyperlink before thinking about using a macro and it didn't work.


    oops ... my mistake - I've tried it again and it works :)
    The first time I've tried to use it for a folder which name contains a ","


    THANKS!!! Problem solved!



    Since this isn't a VBA matter (my mistake) could any moderator delete the post? Thank you!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!