Hi,

I m pulling data from .iqy file to Excel sheet. While doing that, It not only fetches my data from iqy file but also adds ID column in Excel which is auto incrementing. How do I get rid of that ID column which is autoincrementing column in my excel sheet?

Here's my code along with screenshot that shows auto incremented column iD which I want to get rid of.
Delete AutoIncrementingCol.JPG

Sub Get_Standard_Data()
          IQYFile = "C:\Users\shress2\Downloads\owssvr.iqy"
          With ActiveSheet.QueryTables.Add(Connection:= _
              "FINDER;" & IQYFile, Destination:=Range("A1"))
              .BackgroundQuery = True
              .TablesOnlyFromHTML = True
              .Refresh BackgroundQuery:=False
              .SaveData = True
          End With
End Sub