CSV是文本格式文件。

您可以通过"打开文件"来实现。方法。

如果分隔符不正确，您可以在记事本中创建编辑上下文;]

如果你想从选定的范围或工作表中生成CSV文件，我可以推荐你我的工具：
XLS到CSV加载项

Currently I am in the of migration of Excel 2000 to 2010 version. A functionality that works in Excel 2000 macro, which is not working in Excel 2010 macro.

Problem:

CSV data is not getting displayed correctly in Excel 2010.

I have a CSV (Comma Separated Value) file which is generated through macro in excel 2010 environment. My Regional setting is in Germany (Swi tzerland) and Location is Germany. I am trying to open this file in Excel 2010, all data are getting displayed in first column, not getting displayed as comma delimited. When I change my regional as English (United States) and Location as India, Excel showing the data correctly with comma delimited.

What would be the problem? Is the problem with VBA or with Microsoft Windows settings Microsoft office - regional settings compatibility?

I want  do this functionality with my regional settings as Germany.

Thanks,

Subbiah.

CSV is Text format file.

You can make it by "Open file for" method.

If seperator is not correct you can make Edit context in Notepad ;]

If you want to produce CSV files from selected range or worksheet, I can recomend you my tool: XLS to CSV Add-in