|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
录的宏
sub aa()
Dim OperationRegistry, WorkPath
Dim Sh As Workbook, Ar
Dim wb As Workbook
Set wb = Workbooks.Add
Set Sh = ThisWorkbook
Set OperationRegistry = CreateObject("WScript.Shell")
WorkPath = ThisWorkbook.Path & "\"
With wb
Sh.Activate
Sheets("sheet1").Select 'sheet1是需要复制的sheet名
Sheets("sheet1").Copy Before:=wb.Sheets(1)'sheet1是需要复制的sheet名
ActiveWorkbook.SaveAs Filename:=WorkPath & "aaa" & "_" & aday & "_" & atime & ".xlsx", FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False
end sub |
|