base64 encoding??? in a hyperlink more less..

**Mrpimpdave** · 12-11-2009, 01:50 PM

Well what I am trying to do now is add cell A2 into a hyperlink, but heres the kicker.... I need cell A2's numerical value to be base64 encoded...

I.E. track.php?next_controller=stats&next_action=view&next_params=%7B%22user%22%3A%22MTAwMDAwMTY3NjUzMDAz%3D%3D%22%7D
Cell A2=100000167653003
Cell A2 in base 64=MTAwMDAwMTY3NjUzMDAz

Also I am trying to have it open a new window when clicked..
And have a display name of say "User"

This is the site I have used to get base 64 encoding..
http://rumkin.com/tools/compression/base64.php

I know this is asking a lot, I Posted before about using a cell value in a hyperlink and this forum was invaluable.. So now I call on your great wisdom again... I am not even sure if this can be done...

Thank you very much in advance

**DonkeyOte** · 12-11-2009, 02:07 PM

see: http://stackoverflow.com/questions/1...sing-excel-vba

Revised to Late Binding approach this becomes:

Please Login or Register  to view this content.

So if your string is in A2 you would use

Please Login or Register  to view this content.

(obviously remove the = if you wish to embed within another formula - eg ="Apples: "&ENCODEBASE64(A2)&", Pears"

Does that work for you ?

EDIT: to add - the above is a UDF - ie VBA code that should be placed in a stand alone Module - thereafter Macros must be enabled

base64 encoding??? in a hyperlink more less..

LinkBack

Thread Tools

Rate This Thread

Display

base64 encoding??? in a hyperlink more less..

Re: base64 encoding??? in a hyperlink more less..

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions