Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Feb 2010
    Location
    Essex, UK
    Posts
    48
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Excel not passing parameters in hyperlinks

    A deep source of irritation, and I haven't yet found an answer.

    In Excel you can add hyperlinks. Great. Only, if you add a parameter, it doesn't work. For example, I have this hyperlink:

    http://travel.london2012.com/SJPWeb/Pages/JourneyOptions.aspx?jrh=-967981244&o=9100BEXLEY&ot=S&d=8100OPK&dt=V&do=2012 0804&to=1200&dr=20120804&tr=1700&rr=1&pm=PT

    This should populate a journey planning system with Bexley Rail Station set as the origin, Olympic Park as the destination, to travel on 4th August and arrive by 1200. And it does, if you paste it into the address bar of your browser.

    As a hyperlink in Excel, forget it. It cheerfully ignores everything after the first "?" and takes you to the screen which is then helpfully populated with whatever you put into it last time around. Or blank.

    Any thoughts, or any sign that Microsoft might actually make a feature work properly?
    Thanks

    Stuart

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Well, it depends. A hyperlink to a Google search for example will work and pass all the parameters. I suspect the issue is something in the way the asp code works, but I'm not sure and can't as yet locate any definitive documentation.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    New Lounger
    Join Date
    Jan 2013
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exclamation This Fix Worked for Me

    I had the same problem you were having. Somebody pointed me to this fix from Microsoft: http://support.microsoft.com/kb/218153 . Even though my problem was identical to yours and not like the problem described in the KB article, the solution fixed my problem. Hope this helps.

    Edit: I should note that I had to create the keys "9.0", then "Common", then "Internet" (because none of them existed in my registry) before creating the DWORD value of "ForceShellExecute" and setting its value to "1".
    Last edited by cuppettcj; 2013-01-02 at 16:54. Reason: More information

Posting Permissions

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