Copy worksheet to a new workbook using VBA

[HeatherO]

I am currently working on a report that dumps data into an already set up spreadsheeet, and what I want to do is remove the rows that have no data being sent to it. I've done this and now what I want to do is take this sheet that has the rows only that contain data and copy it to a new workbook that I will create and then what I am going to do is not save the previous workbook that I originally deleted all the rows on since I need this one to do more calculations for a macro and it might dump data into those deleted rows. This is really hard for me to describe. Basically I am just wondering how I can copy a sheet that is active to another new sheet in a totally new workbook, and do I have to create that new workbook before I copy it??
Any help is gratefully appreciated.

 

[Nimrod]

These demos copy a sheet into a new workbook. Demo1 copies active sheet while Demo2 copies Sheet1

Sub demo()
ActiveSheet.Copy
End Sub


Sub demo2()
sheets("Sheet1").Copy
End Sub

 

[HeatherO]

Is there anyway though that I can copy the sheet and name the new workbook that it is copying it too?? I wanted to create a new workbook with the name Adv_Sum.xls?

 

[Nimrod]

Sub Demo()
ActiveSheet.Copy
ActiveWorkbook.SaveAs "C:\Adv_Sum.xls"
End Sub

 

[HeatherO]

Thanks a billion. That was so simple I think my mind is just starting to numb out I know my back is.