how to copy 2 sheets from a ws to another ws

[skaswani]

hello

i want to Copy 2 worksheets from one Workbook to New workbook


suppose my sheets names are A and B

how to copy these 2 sheets into NEW WORKBOOK



thanks

[lucas]

Try this I used the macro recorder to get it:
Sub Macro3()
Sheets(Array("A", "B")).Copy
End Sub

[skaswani]

thank you sir, just one quick question.. can i name this (new worksheet) as "daily-report.xls"


thanks

[lucas]

You will have to change the path to save the file and the file name to suit your need.....
Sub SaveSales()
Application.ScreenUpdating = False
Worksheets(Array("A", "B")).Copy
ActiveWorkbook.SaveAs "F:\Temp\Sales.xls"
ActiveWorkbook.Close
Application.ScreenUpdating = False
End Sub