+ Reply to Thread
Results 1 to 6 of 6

Automatically create hyperlink in active cell when creating folders

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    Midwest, US
    MS-Off Ver
    Excel 2010
    Posts
    26

    Automatically create hyperlink in active cell when creating folders

    Hello,

    I borrowed and tweaked the code below to fit my needs. However, I would like to add one more feature.

    When I hit my button to create a new folder, is it possible to have the code automatically create a hyperlink to the folder too??

    Please Login or Register  to view this content.
    I am sure this type of question has been asked already, but I cannot easily find exactly what I need and I am way too new with VBA to figure it out.

    Thanks for the suggestions everyone.
    Last edited by XxCMoneyxX; 05-06-2013 at 11:04 AM.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Automatically create hyperlink in active cell when creating folders

    Hi,

    This is untested!

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    11-07-2012
    Location
    Midwest, US
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Automatically create hyperlink in active cell when creating folders

    I just tried it.

    It does not create a link to the exact folder that I am creating. The second time I tried it it overwrote my cell contents with the word "Link"

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Automatically create hyperlink in active cell when creating folders

    Hi,

    Untested is good that it ran at all - what happens when you click on "Link" - and isn't it being placed beyond the used columns?

    Try:

    Please Login or Register  to view this content.
    Still untested!
    Last edited by xladept; 05-03-2013 at 08:40 PM.

  5. #5
    Registered User
    Join Date
    11-07-2012
    Location
    Midwest, US
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Automatically create hyperlink in active cell when creating folders

    Happy Monday xladept.

    After I spent a weekend away from my sheet I decided that I am making the simple difficult.

    I included a secondary column to my sheet next to my column where the folder name is generated. So your first code you sent me creates what I need. Thank you again.

    Please Login or Register  to view this content.

  6. #6
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Automatically create hyperlink in active cell when creating folders

    You're welcome!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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