Retain Cookies when clicking Excel Links?

So I know the reason why cookies are not "retained" when you click an internal link in Excel (due to how it processes and redirects to the URL) but is there a work around?

I have some links in a spreadsheet that opens a webpage that I use all day, but it prompts me to login, which I want to bypass. I know it is because Excel is sort of "bypassing" the cookies by using some function .dll or some such... but I am trying to find a work around.

I found something online that I though would work but since my links are generated with =HYPERLINK formula it doesn't work. Hoping someone might have some ideas"

This is the info I found online through Google

Please Login or Register  to view this content.

The problem is my links are generated with this code. (Actually I tested this with just a text hyperlink too and all it did was open an Explorer window)

Please Login or Register  to view this content.

All this is our company website, linking me to a search function we use but saving me 3 or 4 steps to get there when I am working in a spreadsheet with values I want to search for.


Any ideas? Thanks in advance! - oh and the workaround has to be something not requiring admin access since this is all local, so I can't do registry edits or anything like that, it has to be within Excel (VBA or other)

Okay so I input the code

Please Login or Register  to view this content.

into the sheet I am using. I put just the text "Search" in B2, then edited the hyperlink and did the place in document linking back to B2.

I can see what is supposed to happen, it opens explorer and should run the link through there (which works manually btw), however when I click the link it opens explorer but that's all that happens, did I miss a step? Thanks for your help by the way, much appreciated.

Originally Posted by jason.b75

Are you certain that the link created is 100% valid?

I can't see that you've missed a step or done anything wrong from what you have said.

I just tried the code from your last post, but replaced the web address in the string with the one for this thread and it worked fine.

Does the link work for you if you try the same?

I think you're right, when I just put in http://www.google.com it then works..so it's something with the link I am using. Not sure though as that link seems to work manually. I will look into it.

It's weird - if i just change the link without the cell reference part, it works in Chrome manually but won't work from within Excel

Example:

Please Login or Register  to view this content.

It just opens explorer but doesn't run the link

It works without the form commands

Please Login or Register  to view this content.

I will just have to work with it..maybe it will not work with form commands in it.

Tried everything, the links work manually but not through excel if I add any of the & commands on it like:

Please Login or Register  to view this content.

They work manually through explorer just not through excel..very strange...

That worked, thanks so much man you rock!

The only issue is I can't mass copy down the link cell as it doesn't do the Cell Reference in sequence (so if my link is referenced to B2, when copied down it makes them all B2) - oddly the links still work it just moves the cursor back to B2..but it still runs the link correctly strangely...

I would paste my file but it has a ton of information about clients - so my apologies

Here's what the spreadsheet looks like:
Attachment 623320

Here's the code:

Please Login or Register  to view this content.

If I save the document and close it, the FIRST time I click a link as long as it's the one matching the cell reference (so clicking Search in B2 for instance) works, but then it gives the type mismatch after that. I assume I have to match the cell reference every time (not sure why though as that worked before)

The issue is creating a new reference every time I add a new line is very tedious (having to click edit hyperlink and change the cell reference)

That's definitely the issue as I tested 3 lines with the proper reference..is there not way to copy cell references down with a table like you would a formula? It only copies the original cell reference when I use auto fill so all my lines reference B2

Sweet - this should work I will try it out, thank you!

Edit:
Worked - thanks so much! Now I can organize it and make it work dynamically since I do reorder and add rows quite often, thanks so much.

I slapped this code in and it seems to work perfect

Please Login or Register  to view this content.