以分号分隔符另存为CSV | 以分号分隔符另存为CSV

本文介绍了以分号分隔符另存为CSV的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我目前正在使用此功能进行保存，但我遇到了问题：

I'm currently use this function for saving, but I have a problem with it:

Private Sub spara()
    ActiveWorkbook.SaveAs Filename:="T:\filepath+ ActiveWorkbook.Name", _
    FileFormat:=xlCSV, CreateBackup:=False
End Sub

它会自动保存，，但我需要保存; 。是否可能改变它如何保存不知何故？

It automatically saves with , but I need it to save with ; in its file. Is it possible to change how it saves somehow?

我已经尝试搜索这个问题，但关于.csv文件保存的所有宏都是如何保存在.csv和如何拆分多个表到.csv 。

I've tried googling around for this issue, but all macros regarding .csv file saving are just how to save in .csv and how to split multiple sheets to .csv .

推荐答案

您的Excel使用哪种语言？如果你的母语使用;默认情况下，您可以传递参数local：= True

Which language does your Excel use? If your native language uses ";" as default, you can pass the parameter "local:=True"

ActiveWorkbook.SaveAs Filename:="C:\Temp\Fredi.csv", FileFormat:=xlCSV, CreateBackup:=False, local:=True

如果没有，你唯一的选择是搜索和替换...

If not, your only choice is searching and replacing afterwards...

这篇关于以分号分隔符另存为CSV的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！