请教如何将ACCESS数据导出到EXCEL时,将EXCEL文件名字设为当前日期.XLS

fengrh

寫在excel裡

Sub auto_close()
Application.DisplayAlerts = False
ss = Format(Date, "yyyymmdd") + ".xls"
ActiveWorkbook.SaveAs Filename:=ss
End Sub