title: Excel macro doesn't work after sometime
body: <p>I have a macro in Excel which gets the data(html table) from a particular link , the macro works fine for 4-5 runs but it gets blank data after that . However if I record that macro again &amp; run it works fine again for 4-5 runs. How can I resolve this ?</p>
  
  <p>Adding the macro below (this is a recorded macro)</p>
  
  <p>With ActiveSheet.QueryTables.Add(Connection:= _
          "URL;http" _
          , Destination:=Range("$A$3")) 
          .Name = _
          "awadmin?commandname=appwatch&amp;project=60115-VENOM&amp;I=1&amp;M=<em>&amp;q=</em>&amp;GO=Submit"
          .FieldNames = True
          .RowNumbers = False
          .FillAdjacentFormulas = False
          .PreserveFormatting = True
          .RefreshOnFileOpen = False
          .BackgroundQuery = True
          .RefreshStyle = xlInsertDeleteCells
          .SavePassword = False
          .SaveData = True
          .AdjustColumnWidth = True
          .RefreshPeriod = 0
          .WebSelectionType = xlEntirePage
          .WebFormatting = xlWebFormattingNone
          .WebPreFormattedTextToColumns = True
          .WebConsecutiveDelimitersAsOne = True
          .WebSingleBlockTextImport = False
          .WebDisableDateRecognition = False
          .WebDisableRedirections = False
          .Refresh BackgroundQuery:=False
      End With // gets the data from the URL </p>
  
  <pre><code>Cells.Replace What:="Display System Objects", Replacement:="", LookAt:= _
      xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
      ReplaceFormat:=False
  Range("C8").Select
  </code></pre>