Closed Thread
Results 1 to 10 of 10

Macro or some way to have a list of names each hyperlink to individual folder

  1. #1
    Registered User
    Join Date
    12-22-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    29

    Macro or some way to have a list of names each hyperlink to individual folder

    Hi, I am very new at all this. I have an excel file that has several columns. Column B has around 3200 last names and I have a folder for each of those names at C:\Users\Administrator\Documents\macro folder\xxxxx . I want to be able to have each of those names as a hyperlink on excel file to there respective folders. The folders are the named the same as the last names in the excel file. I was able to copy a macro that created the folders but I really not sure how it worked.
    Thanks, Chris

  2. #2
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Macro or some way to have a list of names each hyperlink to individual folder

    One way is to use the hyperlink formula in a separate column.

    E.g. for the hyperlink of the last name on the second row:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-22-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Macro or some way to have a list of names each hyperlink to individual folder

    Would I have to do this for each name? There are over 3000 names

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Macro or some way to have a list of names each hyperlink to individual folder

    Hi and welcome to the forum

    You should be able to just copy that down
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    12-22-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Macro or some way to have a list of names each hyperlink to individual folder

    Hi
    I do not understand. The formula that was provided was for one line B2. I have names from B2 to B3600. All names have separate folders as stated. The name of each folder matches the name of each line.
    Thanks Chris


    =hyperlink("C:\Users\Administrator\Documents\macro folder\" & B2)
    Last edited by ckshann; 12-23-2013 at 10:47 AM.

  6. #6
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Macro or some way to have a list of names each hyperlink to individual folder

    Hi ckshann,

    Let's say that you put the hyperlink formula in C2 (with reference to B2 without locking it to this cell), then you just copy the cell down to C3600 and it should follow, matching each name and linking to different folders

  7. #7
    Registered User
    Join Date
    12-22-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Macro or some way to have a list of names each hyperlink to individual folder

    Hi, That worked, I was hoping just to make the name in the cell the hyperlink. The formula takes up a lot of space. Your method does give me the hyperlink to the folder. I greatly appreciate your help
    Chris

  8. #8
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Macro or some way to have a list of names each hyperlink to individual folder

    ckshann,

    Its against the rules to post the same thread in the paid as well as free forum. Is this thread completely solved?

    If yes, what do you want to do with the thread in the paid forum. One of the users has already locked it and could be working on a solution for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  9. #9
    Registered User
    Join Date
    12-22-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Macro or some way to have a list of names each hyperlink to individual folder

    I was looking for a different approach (having the names be the hyperlink rather than solution provided) but the solution provided did work. Sorry I posted it in both areas, I thought it had gone unattended in the paid area.
    Chris

  10. #10
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Macro or some way to have a list of names each hyperlink to individual folder

    Thread closed.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to create hyperlink list of every file in a folder, subfolders
    By itmanusa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2013, 12:43 PM
  2. Macro to list folder names within a directory
    By praveen_sn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2013, 01:30 AM
  3. Macro to list folder names within a directory
    By munkee in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-02-2010, 01:26 PM
  4. need hyperlink to go to individual folder on server
    By phudson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2009, 01:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1