| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help Taking alot data from one sheet (if not blank) and copying toa list on another sheet. | Excel Worksheet Functions | |||
| Copying the repeated data of the previous sheet to the next sheet | Excel Discussion (Misc queries) | |||
| Dynamic column chart - copying from Sheet to Sheet. | Excel Discussion (Misc queries) | |||
| Dynamic column chart - copying from Sheet to Sheet. | Charts and Charting in Excel | |||
| 2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
Linear Mode
