如题所述
第1个回答 2013-07-20
Sub aa()
ThisWorkbook.SaveAs "C:\Documents and Settings\Administrator\My Documents\Downloads\" & "OFF" & Date & ".xls"
End Sub追问
Dim wb As Workbook
Set wb = Workbooks.Add
wb.SaveAs "d:\" & "OFF" & Date & ".xls"
End Sub
ThisWorkbook.SaveAs "C:\Documents and Settings\Administrator\My Documents\Downloads\" & "OFF" & Date & ".xls"
End Sub追问
出现如图错误提示
Dim wb As Workbook
Set wb = Workbooks.Add
wb.SaveAs "d:\" & "OFF" & Date & ".xls"
End Sub
刚刚那句也没有错,我都是测试过了;你用这个使下
第2个回答 2013-07-20
Sub test()
ThisWorkbook.SaveAs "C:\Documents and Settings\" & "OF" & Format(Date,"yyyymmdd") & ".xls"
End Sub本回答被网友采纳
ThisWorkbook.SaveAs "C:\Documents and Settings\" & "OF" & Format(Date,"yyyymmdd") & ".xls"
End Sub本回答被网友采纳
第3个回答 2013-07-20
可用workbooks 的saveas 方法。。查看下帮助就好。。