在Excel 2010中打开宏生成的CSV文件时出现问题。 [英] Problem on opening macro generated CSV file in Excel 2010.

问题描述

目前我处于Excel 2000到2010版本的迁移中。在Excel 2000宏中运行的功能，在Excel 2010宏中无效。

  ;

问题：

< p style ="margin：0in; font-family：Calibri; font-size：11.0pt">在Excel 2010中无法正确显示CSV数据。

 

我有一个在excel 2010环境中通过宏生成的CSV（逗号分隔值）文件。我的区域设置在德国（Swi tzerland），位置是德国。我试图在Excel 2010中打开
这个文件，所有数据都显示在第一列，而不是以逗号分隔显示。当我将我的区域更改为英语（美国）和位置为印度时，Excel以逗号分隔正确显示数据。

 

会出现什么问题？是VBA问题还是Microsoft Windows设置Microsoft Office - 区域设置兼容性？

我想要 使用我的区域设置作为德国执行此功能。

< p style ="margin：0in; font-family：Calibri; font-size：11.0pt">谢谢，

Subbiah。

解决方案

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

这篇关于在Excel 2010中打开宏生成的CSV文件时出现问题。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！