Convert comma delimited.txt or .csv file TO pipe delimted.txt file
Posted on 2003-02-28
Alright here is the deal, I have almost had this a few times and cant seem to complete.
Using a macro (from within excel or access), I need to convert a long list of files like this:
From comma (') delimited to pipe (|) delimited. When done running the code the files could have the same name or they could have the same name.txt and be in a differnt directory. (whatever)
Here is the catch, I need to figure out a way to accomplish this WITHOUT changing the regional settings in the control panel from using a (') to using a (|).
OR from in an excel doc that I am about to save can someone tell me how I can write a macro that would use the GetSaveAsFilename command and allow me to not only speify the save as type (which would be .csv) BUT also specify that I want to deliniate the file with |'s and not 's?
(I could accomplish task this way because that long list of .csv files gets created this way. one save as at a time)
Winner gets 75 points
I look forward to a soloution!