I would like to save a file .csv format using pipe delimited. Currently I will change the region and settings list separator on my computer to a pipe then save the file as .csv. I have to keep doing this tho, every time i run that file. Is there a way in vba to do this usine the .saveas function. I could probably do a find and replace to, but would like to avoid that as well.

thanks,
Mike