Open CSV file, format data and write output to a text file.

  • Thread starter Thread starter BristolBloos
  • Start date Start date
B

BristolBloos

Hi All,

Through my Excel VBA i want to
1. Open a csv file
2. Read each row
3. Select few fields
4. Format them
5. Concatenate them as a single text separated by "#"

and

6. Finally write the output into a text file


I know the name and location of the input csv file and therefore I
don't want the user to open it manually. Rather the file should be
opened automatically using VBA code for reading.


Some suggestions and code examples please.

Thanks & Regards,
Prasad
 
Back
Top