Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open CSV file, format data and write output to a text file.
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" wrote in message oups.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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO OPEN A WRITE PROTECTED FILE (USB) | Excel Discussion (Misc queries) | |||
Open a print output sent to file | Excel Discussion (Misc queries) | |||
Cannot open file for output | Excel Programming | |||
How do I import text file, analyze data, export results, open next file | Excel Programming | |||
Open delimited text file to excel without changing data in that file | Excel Programming |