Edit csv text file with VBA

S

sJ

I receive a csv text file in Excel that I need to change the first row of
data in. Doing this in Excel and saving the file converts numbers such as
000200 to 200 etc. Is there a way to do this with the VBA Open and Print
statements?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Working outlook via vba code with xlsx - error 0
Trying to create custom labels from an csv file + Need items numerically counted out 0
CRM concept 0
CSV files and having numbers and strings in there... 9
csv file truncating zero values 0
Embedded Excel into Word with Tables 0
Merging from an Excel file with graphics 1

Top