How To keep Columns when Using a Macro to automatically save a .csv file

I'm using a Macro that when activated saves a file as a .csv (MS-DOS) file. When saving it automatically it saves all information to Column A with a comma delimter. When you save the .csv (MS-DOS) file manually it prompts you with an "Error Message" . ".csv may contain features that are not compatible with CSV (MS-DOS). Do you want to keep the workbook in this format? When you click Yes the file is saved with all of the columns retained. This is what I want, but within a Macro.

*Plain and simple - Current Macro saves automatically as a .csv file with all data in column A seperated by commas (Correct I know)

Issue: I used these .CSV (MS-DOS) files to import data into our ERP system, the ERP reads the information Column specific so the correct data has to be in the correct format. Only .CSV (MS-DOS) file can be imported.

**I'm wondering what about that "Error Message" Prompt and Clicking Yes retains all of the column locations within the .CSV File? And how can I get this to do the same in my VBA Code.

Any help is greatly appreciated - I've been stumped on this for a month now.

Code:

Please Login or Register  to view this content.

Thanks,

Jon