I use VB within MS office and would like to run IE from Excel. The codes are like these:

VB Code:
  1. urlHeader = "http://bla.blablalalal"
  2. Set IE = CreateObject("InternetExplorer.Application")
  3. For r = 2 To 1000 Step 1
  4.     Str = Cells(r, 2).Value
  5.     url = urlHeader & Str
  6.     IE.Navigate (url)
  7.     While (IE.ReadyState <> 4)
  8.         Application.Wait 10
  9.     Wend
  10.     sRet = IE.Document.DocumentElement.OuterHTML
  11.     '........
  12. Next r
This works fine when len(url)=<2048, but longer url is truncated by IE. Could you give me suggestions to get around this problem? Thanks a lot.

Nanfei