ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Edit csv text file with VBA (https://www.excelbanter.com/excel-programming/428534-edit-csv-text-file-vba.html)

sJ

Edit csv text file with VBA
 

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?





All times are GMT +1. The time now is 06:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com