I need to save copy of a workbook under diferrent names...

I currently am using the SaveAs method but this switches to the newly
created file and I would like to remain within the original file. How can
this be done.

Also, is it possible to create these copies without copying the vba in the
main file, just the worksheet data?

Thank you for the help,

QB