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

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

http://www.cpearson.com/excel/imptext.htm import/export text files

at Chip Pearson's site should get you started.

Some References:
http://web.archive.org/web/200404050...eio/fileio.asp
File Access with Visual Basic® for Applications

http://support.microsoft.com/default...b;en-us;151262
Working with Sequential Access Files

http://www.applecore99.com/gen/gen029.asp

--
Regards,
Tom Ogilvy


"BristolBloos" <prasad.vanka@computershare.co.uk> wrote in message
news:1129642407.501459.191480@g49g2000cwa.googlegroups.com...
> 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
>