URLEncoding in VBA

[jedownsjr]

Does anyone know how to URLEncode using VBA? I have a URL that has special characters (such as the @ character), and I need to make sure that this is passed as a valid URL, using something equivalent to the ASP command URLEncode(URLVariableHere).

 

[danvlas]

If you want to open the URL from VBA:

FollowHyperlink "

http://blahblah.org/@thread@first@F@75@D-,D@ALL?E="

If you want to store it in a hyperlink field of a table, enclose it between #:

FieldName = "#" & YourURL & "#"

HTH






Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[jedownsjr]

Does this code actually encode the URL? The problem I was having was that the web page would not open because of some special characters in the URL that messed things up. If I was using ASP instead of VBA, I would use URLEncode to tranlate the URL before passing it. Is the translation built into the VBA commands you recommended? -Thanks-