Browsing All posts tagged under »Excel Snippets«

Automating Internet Explorer: Filling Up Web Dialog Form

April 2, 2011

0

In codeforexcelandoutlook, Jimmy Peña demostrated internet explorer automation, sending to and retrieving information from the web using VBA. In some cases that you might require a code to fill up string/numbers values to a web dialog form, here I will demonstrate how to add another possibility in automating internet explorer. Some web forms make use of […]

VBA Function to Revert URL Encoded String to Regular String

March 29, 2011

0

URLEncode function puts legal string into the navigator url. I would use the following function to revert the URLEncoded/Escaped string to human-readable text, used in parsing web document values for example. 'revert urlencoded characters to regular texts Function UnEncodeURL(EscapedURL As String) As String Dim i As Integer Dim txt As String Dim hexChr As String […]