Excel link to website not working

  • Thread starter Thread starter jgadbois
  • Start date Start date
J

jgadbois

Hi,
I have an excel spreadsheet at work that contains links to an
internal company website. Each of these links contains a query string.
My problem is that the query string is being ignored when I click on
the link. Here's an example link..

http://my-parr/parr/req?action=taggedmain&projid=26&tag_id=2

When I click on the link I get redirected to the main page of the site
I am trying to go to. If I copy and paste the url into the browser it
works fine. Any suggestions?

Thanks,
John Gadbois
 
Access works really well for linking to a HTML page.

check it out.

in access, right-click link, files of type = HTML and you can put in
the whole URL with querystring.

I like it a lot more than Excels linking.. because it WORKS
 
Unfortunately, I don't think that I can go with that option. The
spreadsheet is pretty comprehensive and contains much more than just
the links that couldn't be ported to access.
 
Ok, I think I'm on the right track to finding a solution. I got the
links to work by adding code to the Worksheet_FollowHyperlink event
handler to execute a sub that will start a new instance of IE and point
it to the target of the hyperlink. My question now is this...can I
somehow suppress the IE window that pops up by default when I click on
the hyperlink? As it is now, when I click on the hyperlink two windows
pop up; the first one in which the link is not working, and the second
one which is instantiated by the macro and does work. I would like to
get rid of the first window.
 
if the xls is too complex; it is better to change it NOW then when it
is more complex
what are you going to do when you hit the 64k row limit? lol

you've chosen the wrong architecture. excel is a disease.

-aaron
 
Back
Top