excel彩通吧 关注:5贴子:65
  • 0回复贴,共1

原名保存文件

只看楼主收藏回复

Public Sub 技巧1_042()
Application.EnableEvents = False
ActiveWorkbook.Save
Application.EnableEvents = True
End Sub
关闭不保存,不显示警告信息框
Public Sub 技巧1_044()
Application.DisplayAlerts = False
ThisWorkbook.Close
Application.DisplayAlerts = True
End Sub
保存为指定路径和文件名的Excel2003文件
ActiveWorkbook.SaveAs Filename:="D:\sfg.xls", FileFormat:=xlExcel5


IP属地:山东1楼2015-05-04 23:39回复