Copying sheet to its own wb
 

i need to copy sheet(5) to its own workbook and then save
that wb as "file_" & worksheets(3).range("g10").text
& ".xls", is this possible

thanks so much

Copying sheet to its own wb
 

Hi Rhonda,

Of course it is <vbg.

Worksheets(5).Copy
Set oWb = ActiveWorkbook
owb.saveas filename:= "file_" & worksheets(3).range("g10").text &
".xls",


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Rhonda Johnson" wrote in message
...
i need to copy sheet(5) to its own workbook and then save
that wb as "file_" & worksheets(3).range("g10").text
& ".xls", is this possible

thanks so much

Copying sheet to its own wb
 

set bk = Activeworkbook
bk.worksheets(5).Copy

ActiveWorkbook.Saves "file_" & _
bk.worksheets(3).range("g10").text & ".xls"

--
Regards,
Tom Ogilvy

"Rhonda Johnson" wrote in message
...
i need to copy sheet(5) to its own workbook and then save
that wb as "file_" & worksheets(3).range("g10").text
& ".xls", is this possible

thanks so much

Copying sheet to its own wb
 

Just a heads up,

Since the single sheet workbook (the copy of worksheets(5)) is the
activeworkbook, then Worksheets(3).Range... would refer to that workbook and
raise an error.

worksheets(3) needs to be qualified with the source workbook reference

--
Regards,
Tom Ogilvy


"Bob Phillips" wrote in message
...
Hi Rhonda,

Of course it is <vbg.

Worksheets(5).Copy
Set oWb = ActiveWorkbook
owb.saveas filename:= "file_" & worksheets(3).range("g10").text &
".xls",


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Rhonda Johnson" wrote in message
...
i need to copy sheet(5) to its own workbook and then save
that wb as "file_" & worksheets(3).range("g10").text
& ".xls", is this possible

thanks so much

Copying sheet to its own wb
 

Thanks Tom, missed that.

Bob

"Tom Ogilvy" wrote in message
...
Just a heads up,

Since the single sheet workbook (the copy of worksheets(5)) is the
activeworkbook, then Worksheets(3).Range... would refer to that workbook
and
raise an error.

worksheets(3) needs to be qualified with the source workbook reference

--
Regards,
Tom Ogilvy


"Bob Phillips" wrote in message
...
Hi Rhonda,

Of course it is <vbg.

Worksheets(5).Copy
Set oWb = ActiveWorkbook
owb.saveas filename:= "file_" & worksheets(3).range("g10").text &
".xls",


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Rhonda Johnson" wrote in message
...
i need to copy sheet(5) to its own workbook and then save
that wb as "file_" & worksheets(3).range("g10").text
& ".xls", is this possible

thanks so much