VB 写入 excel 后,自动先“是”保存

2024-12-19 22:01:30
推荐回答(1个)
回答1:

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\administrator\桌面\qqqqq.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
ActiveWindow.Close