Excel Query in VBA without Column Headers

**zhb12810** · 07-13-2012, 02:49 PM

Hi, Not sure if this is in the right place but.......

I just wondered if its possible that when you run a query via VBA you can omit the columns headers and return the query into the specified cell.

Any help would be appreciated

Many Thanks

**Richard Buttrey** · 07-13-2012, 03:21 PM

Hi,

Just checked one of mine and the syntax is the .TextFileStartRow
i.e.


With Sheets("mysheet").QueryTables.Add(Connection:="myconnection;" & "myfile", _
& Destination:=Sheets("Mysheet").Range("myrange").Cells(1, 1))
      .TextFileStartRow = 2
'etc..

End WIth

**zhb12810** · 07-13-2012, 03:43 PM

Thanks for that but it doesn't seem to work. I'm actually pulling the data from a DBF file if that makes any difference

Thanks again

**Richard Buttrey** · 07-13-2012, 03:56 PM

Might be worth while googling to see if there's an equivalent of the .TextFilesStartRow syntax.

You could always add a line of code

Range("myimportdata").cells(1,1).EntireRow.Delete