View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JP[_15_] JP[_15_] is offline
external usenet poster
 
Posts: 2
Default vba code to replace first row in CSV file

I receive CSV files that I need to open and replace the first row of data
with different column headings and close and save the file.

When I do this in Excel and save it, it truncates data below the first row
that begins with 0. For example, 000300 is saved as 300.

Is there a way to do this with the Open and Print statements in VBA?