Hi All
Got a really tricky one... Can a excel sheet be saved as CSV but with Pipe "|" delimiter instead of ","?
I know there is a way to change windows wide delimiters from "," to "|", but that is not ideal, is there a way for excel VBA code to do it?
Or alternatively, VBA code that changes the windows value, saves a CSV, and then changes back the windows value to a ","?
Thanks in advance.