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

[JonTTrier]

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:

ActiveWorkbook.SaveAs Filename:= _
"C:\Users\jonathan.trier\Desktop\Destination Folder Adobe\" & "Adobe_CLC 5.0_North America_USD_" & Format(Date1, "YYYY_MM") & " CSV" & ".csv", FileFormat:= _
xlCSVMSDOS, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False


Thanks,

Jon

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/excel-...o-saves-without-columns-kept.html#post3253431

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: </SPAN>Forum Rules).</SPAN>