VBA Macro to create Tab Delimited CSV file

[XcelNoobster]

So I have a VBA Macro that formats a sheets that contain Column A, B and C. Is it possible to create a macro that adds a TAB separating the Columns so when I save it as a CSV, I get a Tab Delimited CSV file instead of a comma?

 

[Joe4]

Tab-delimited and CSV files are two different things entirely. CSV actually stands for "Comma Separated Value".
So a tab-delimited files save with a tab as the delimiter. A CSV file saves with a comma as the delimiter.

However, you should be able to get the VBA you want pretty easily.
Just turn on your Macro Recorder and record yourself saving the file as the "Text (Tab Delimited) (*.txt)" file type, and you will have the VBA code you need to do this.
You can give the file any name/extenstion you desire.