VBA另存为特殊字符错误 [英] VBA Save As special character error
问题描述
下面的代码运行完美.为了进行内部报告跟踪,我在文件名的前面附加了"[1944]".现在它正在向我退还运行时错误'1004'".
This code below was running perfect. For internal report tracking purposes I've appended "[1944] " to the front of the file name. It's now kicking back "Run-time error '1004'" at me.
错误1004清单
- 文件夹存在
- 文件不是只读的
- Len(文件路径)<218
上一节中的引用未使用以下字符<>?[]:|或*
Last section references not using the following characters < > ? [ ] : | or *
但是,如果我转到文件夹位置,则可以使用[]重命名它,没问题.我什至可以为此文件加上标题并使用VBA启动它那么,为什么不能保存其中的文件.
But if I go to the folder location I can rename it using [ ] no problem. I can even title a file with this and launch it using VBA So why can't I save a file with it in.
有人为我工作吗?
非常感谢!
ActiveWorkbook.SaveAs Filename:= _
strfilepath & "[1944] TSA34_MI_" & strdt & ".xlsb" _
, FileFormat:=xlExcel12, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
推荐答案
我能想到的唯一解决方法是在文件关闭后重命名.
The only workaround I can think of is renaming the file once it is closed.
为此,您可以使用 Name
语句.请参见 MSDN文档.
To do this you can use the Name
statement. See MSDN documentation.
Name "C:\Users\lturner\Documents\myWorkbook.xlsb" As "C:\Users\lturner\Documents\[1]myWorkbook.xlsb"
除此之外,我认为不可能将工作簿的名称保存在方括号中.
Aside from this, I don't think it's possible to save the workbook with square brackets in the name.
这篇关于VBA另存为特殊字符错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!