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?
|