Importing a CSV file, would like to skip first row in Excel

[abright52]

I am trying to import a CSV file that is generated as a log on a
machine that we have. I have created my own custom headings for the
columns in the first row of the Excel Doc. I am able to import
starting on the second row of the CSV file to remove the existing
headings, but the data still overwrites my headings since it wants to
start the import on the first row of the Excel file.

I cannot edit the existing headings that the machine outputs in the
logs. I would like to find a solution that is as user-friendly as
possible.

Thanks in advance.

 

[Bernie Deitrick]

abright,

Import the whole file (including the header row), then use code like this to
put in your desired headings:

Range("A1").Value = "Heading for column A"
Range("B1").Value = "Heading for column B"

etc...

HTH,
Bernie
MS Excel MVP