VBA - Saving a file to .csv

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

The only way I know of doing this is to create a new workbook, concatentate the data into single cell rows with a "pipe" delimiter in that book and then save that workbook as a txt file (with .csv as the extension).

I'm surprised there isn't any easy way to do this. Searching all over the internet and there isn't a simple answer. It's not the end of the world, but it would erase one extra step in the procee. Thanks for the idea.

The new workbook solution can be solved using VBA to automate the whole process however theres also no reason why you cant cycle through your cells and write them independantly out to a .csv file inserting pipe chars between each cell. Its a bit more code than a standard transferspreadsheet line of code but fairly easily done, it just depends on your workbook setup.