Problem creating CSV File

[mzzyyy]

Hi all,

I am new to VBA and I am stuck in this issue for the last 2 days Please suggest me some solution. I am trying to create csv file from excel file. The file gets created but all the columns merge into just one column. i.e its not comma separated.
The piece of code I am using for creating the csv is below :-
wkb.SaveAs FileName:="C:\Users\Public\EGM.csv", _
FileFormat:=xlCSV, CreateBackup:=False
wkb.Close savechanges:=False


Can anyone help me with this?

 

[Joe4]

Welcome to the Board!

Seeing as this appears to be an Excel question and not an Access one, I moved it from the Access forum to the Excel forum.
CSV files are text files, and therefore really do not have "columns". Each field is just separated by a comma.
What program are you using to view the CSV file after it has been created?
If you take a look at in NotePad or WordPad, they should see it exactly as it really is.
If you open it in Excel, some conversions may be done to it, and it may not be a true representation of what you really have.

 

[mzzyyy]

Thanks Joe4. I am trying to open it by just double clicking it and it shows all the data in one column without any comma separation. I opened the file with notepad and there is not comma in it.

 

[Joe4]

What does the data look like in Excel before you try saving it as a CSV file?

 

[mzzyyy]

Is there a way I can attach the screenshot here? The "insert Image" link does not insert the image but a link to the content.
The data in excel is saved in multiple columns i.e 10 columns, I am copying the data , creating a new CSV pasting excel data to the CSV File and adding 2 new columns to it.

 

[Joe4]

There are instructions on how you can post images found in the "Posting Aids" section of this link here: http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html. There is also a "Test Here" forum on this site that you can use to test those tools before using them in your threads.

Also include any other VBA that pertains to this task.

 

[Joe4]

The other option is to upload the file to a file share site, and provide a link to it here.
We usually like to save that as a last resort, as many people have limitations on downloading files from the internet due to security concerns.