我在mac和windows之间遇到一个奇怪的事情,它在Windows上打开时在vba代码中更改字符串(在mac上开发)
我有以下函数返回格式字符串在mac上编码:
Function FormatHelper(reqFormat As String) As String
Dim format As String
If reqFormat = "Accounting" Then
format = "_-* #,##0.00 €_-;-* #,##0.00 €_-;_-* ""-""?? €_-;_-@_-"
ElseIf reqFormat = "Percentage" Then
format = "0.00%"
Else
format = "General"
End If
FormatHelper = format
End Function
format
在windows上打开时更改为:
format = "_- *#.##0,00 Û*_*-;-* #.##0,00 Û_-;_-* "-"?? Û_-;_-@_-"
如何让VBA不变?
编辑:该函数调用如下:
dataSheet.Cells(currRow, 59).NumberFormat = FormattingModule.FormatHelper("Accounting")