Create a workbook
 

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

Create a workbook
 

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

Create a workbook
 

Hi Rowan.

Thanks.

I will trie this later today

Mike
--
Nil Satis Nisi Optimum


"Rowan" wrote:

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

Create a workbook
 

It was perfect.

Thank you Rowan.

Mike
--
Nil Satis Nisi Optimum


"Rowan" wrote:

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