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!!