+ Reply to Thread
Results 1 to 7 of 7

Hyperlink problem.. Get rid of %20

  1. #1
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Hyperlink problem.. Get rid of %20

    Hi all

    I have an excel sheet, where are stored records about new installations. An excel file created for each installation and stored in a folder on a disk D:\. So there are over than 900 excel files.

    After "OK" button is pressed by the user, an excel file is created & saved in appropriate folder. All files named as: 12.02.2012 5889, where "5889" is installation number. There are links in main excel sheet. Each link is linked to appropriate file so anyone could open a file w/o searching in a folder

    But recently, a space in all links were replaced with "%20". I understand, the "%20" means blank but also it causes a problem.. a user can't open a file by pressing on a link!

    I wrote a simple macro which edit all hyperlinks... but "%20" stays after editing. Then I started removing all "%20"'s manually, but "%20" stays after I press OK button.

    I can't use an underscore in my hyperlinks to fix the issue, because I will have to rename over 900 files...

    So, what to do?
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, «Born in USSR»
    Vusal M Dadashev

    Baku, Azerbaijan

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,596

    Re: Hyperlink problem.. Get rid of %20

    Are you sure the %20 are the problem?

    If I create a hyperlink to a file with space in the name the address includes the %20 but the 'friendly name' doesn't.

    How did you create the hyperlinks?
    If posting code please use code tags, see here.

  3. #3
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Hyperlink problem.. Get rid of %20

    the Hyperlink is created using this line

    Please Login or Register  to view this content.
    It worked before.... But not now..

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,596

    Re: Hyperlink problem.. Get rid of %20

    That creates the URL address, but how do you create the actual hyperlink?

  5. #5
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Hyperlink problem.. Get rid of %20

    Please Login or Register  to view this content.

  6. #6
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Hyperlink problem.. Get rid of %20

    this method created and still creates proper hyperlinks... But my old records are "corrupted", and do not open the file on click....

  7. #7
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Hyperlink problem.. Get rid of %20

    Solved by moving all data into new wb....

+ 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