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

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.

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

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



"abright52" wrote in message
oups.com...
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.