priya,

Why not just use JKP's suggestion above? It would eliminate the need to build the .iqy file every day..

I am a little confused about your followup question.. Are you saying that your cell has data in mm/dd/yyyy format and you want the data to be in mm%2Fdd%2Fyyyy format?
%2F is the same as / (2F in hex is equivalent to 47, ascii character code 47 is "/"), it is the URLEncoded equivalent

Whichever way you're looking to translate, use the Replace function[vba]Replace("04%2F10%2F2007", "%2F", "/")
'or
Replace("04/10/2007", "/", "%2F")[/vba]Matt