我尝试在没有警告的情况下保存
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\Owner\Desktop\xxx\test.xlsx", _
ConflictResolution:=xlLocalSessionChanges
但仍然得到这个It is already exists do you want to replace
thing
如何保存和替换而不发出警告?
尝试将其包装在开头的 Application.DisplayAlerts = false 和结尾的 Application.DisplayAlerts = true 中。就像是:
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\Owner\Desktop\xxx\test.xlsx", _
ConflictResolution:=xlLocalSessionChanges
Application.DisplayAlerts= True
http://msdn.microsoft.com/en-us/library/office/ff839782(v=office.15).aspx http://msdn.microsoft.com/en-us/library/office/ff839782%28v=office.15%29.aspx
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)