程序:
msg = MsgBox("合同:" & b(h2, 2) & "参数表已经存在,是否替换?", 1 + 32 + 256)
If msg = vbOK Then
xlBook.SaveAs ("d:\新建文件夹\" & b(h2, 2) & ".xls")
End If
请问该语句格式应该是怎么写?
我试过:
xlBook.SaveAs ("d:\新建文件夹\" & b(h2, 2) & ".xls",xlLocalSessionChanges)不行;
xlBook.SaveAs ("d:\新建文件夹\" & b(h2, 2) & ".xls",ConflictResolution=xlLocalSessionChanges)不行;
a=
xlBook.SaveAs ("d:\新建文件夹\" & b(h2, 2) & ".xls",xlLocalSessionChanges)不行;
请问:正确的表达方式应该是怎样的???
看看语法格式啊。
表达式.SaveAs(FileName, FileFormat, Password, WriteResPassword, ReadOnlyRecommended, CreateBackup, AccessMode, ConflictResolution, AddToMru, TextCodepage, TextVisualLayout, Local)
FileName和ConflictResolution中间还有那么多参数呢。
SaveAs("d:\新建文件夹\" & b(h2, 2) & ".xls",,,,,,,2)
SaveAs("d:\新建文件夹\" & b(h2, 2) & ".xls",,,,,,,xlLocalSessionChanges)