Exporting to CSV using Pipe

Hi
I am modifying an old VBA script, and need to now export the file to csv using | (pipe) instead of , (comma).

I'm not sure where to change this.
below is the part of the script that saves the file, and i'm hoping that this is where it may be changed to say which type of deliminator to save it with.

    Sheets("Output").Move
    ActiveWorkbook.SaveAs Filename:=sFileNamePath, FileFormat:=xlCSV, CreateBackup:=False
    ActiveWorkbook.Close SaveChanges:=False