try:

Sheets(1).Copy
ActiveWorkbook.SaveAs Filename:="C:\Temp\NewBk.xls" '<change as required

Regards
Rowan

"Michael" wrote:

Hi.

I have a macro in one workbook, i want to copy one of the sheets in that
workbook to another workbook who doesnt exist.

Is there a code that makes it possible to create a new workbook, its name
and decide were it should be located (folder)

Michael
--
Nil Satis Nisi Optimum