本例假设文件另存为:C:\aaa.xls,你可以自行修改请在ThisWorkBook对象中输入如下代码:Private Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveWorkbook.SaveAs Filename:="C:\aaa.xls", _
FileFormat...
excel自动另存需要编写宏函数。可以在ThisWorkBook对象中输入代码完成,代码如下:Private Sub Workbook_BeforeClose(Cancel As Boolean) ActiveWorkbook.SaveAs Filename:="C:\aaa.xls", _ FileFormat:=xlNormal, Password...