View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Pytel Frank Pytel is offline
external usenet poster
 
Posts: 103
Default Parse a txt file and save as csv?

Hello;

I am trying to come up with some vba that will parse a txt file. There are
two files that come with different size delimited strings. I would like to
try to find a generic script that will parse the string lengths according to
their size and then add a comma after the end of the string length. I would
then like to save it into a csv file with line breaks. Can anyone direct me
to an accurate solution.

The string lengths are different, but I don't mind having two separate
scripts to run on the separate files.

Any help or direction would be greatly appreciated.

Thanks

Frank Pytel