sub 另存()
workbooks.add(1)
application.displayalerts = false
thisworkbook.sheets("工作表名").cells.copy activesheet.range("A1")
activeworkbook.close true
application.displayalerts = true
end sub
sub 另存()
workbooks.add(1)
application.displayalerts = false
thisworkbook.sheets("工作表名").cells.copy activesheet.range("A1")
activeworkbook.close true
application.displayalerts = true
end sub