Excel macro to munipulate a text file


Posted by Eric-Russell on July 27, 2001 11:10 AM

I have a excel file, but I need to have a macro that will open a txt file in wordpad to do some munipulation (add some spaces and retunrs here and there to line up information) before my excel program can extract some information from it. I would like for this txt document to stay in wordpad as it will be put out on a server that requires it to be in this certain form. So-Can a excel macro be used to munipulate a txt document and what commands do I need to research further. I just need a starting point.

Thanks a Million!!



Posted by Gerald Young on August 26, 2001 3:10 PM

Awk is a great way to accomplish this. It is relatively easy to write the script language to do this. AWK.EXE free... available here: http://www.simtel.net/pub/pd/51371.html .. if you have start and end samples, It would be my pleasure to assist you...