How to decode Rediffmail link

Many times if u received some link in rediffmail, it is encoded by rediff in some format which may not be accepted by proxy giving security warning message, so here is macro written to convert it to actual URL.

So here is what u need to do :-

step 1) Copy and paste the following two code snippets into module section of VB editor window

=== copy above below (without these lines)===

Sub Convert_Link()

' programmed by mdp

Call FR("%3A", ":")
Call FR("%2D", "-")
Call FR("%3D", "=")
Call FR("%2F", "/")
Call FR("%3F", "?")
Call FR("%5F", "_")
Call FR("%2E", ".")
Call FR("%26", "&")


Call FR("http://www.rediffmail.com/cgi-bin/red.cgi?red=", "")

End Sub

Sub FR(F_What, R_This)
Cells.Replace What:=F_What, Replacement:=R_This, LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
End Sub

=== copy above code ===

step 2) save this file with some name
step 3) when u receive link through rediff account, copy link to this excel sheet in any cell and press run macro button, then it will show convert_link program name, run that program, which will automatically replace this link with decoded link, copy this link and paste into ur browser :-)

so enjoy :-) cheers !!