Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Excel tab (worksheet) to another Excel file
Hi!
I have a question about Excel tabs (worksheets) Is there a possibility to copy a tab-page (worksheet) from an Excel file to another Excel file. I know that it is possible within the same Excel file, but is it also possible to copy outside this file? Example: Sheet X with worksheet ABC DEF GHJ Sheet Y I want to copy DEF from worksheet X to sheet Y Kind regards, Stefan van der Hooft. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Excel tab (worksheet) to another Excel file
With Workbooks("Y.xls")
workbooks("X.xls").Worksheets("DEF").copy After:= _ .Worksheets(.worksheets.count) End With as an example. Both workbooks must be open. -- Regards, Tom Ogilvy "Stefan van der Hooft" wrote: Hi! I have a question about Excel tabs (worksheets) Is there a possibility to copy a tab-page (worksheet) from an Excel file to another Excel file. I know that it is possible within the same Excel file, but is it also possible to copy outside this file? Example: Sheet X with worksheet ABC DEF GHJ Sheet Y I want to copy DEF from worksheet X to sheet Y Kind regards, Stefan van der Hooft. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Excel tab (worksheet) to another Excel file
Dear Tom Ogilvy,
Thank you for your reply, however I have one question left: - I want to copy several worksheets from several excel files through a button on a MS Access form, is this possible with the mentioned below code? Kind regards, Stefan van der Hooft "Tom Ogilvy" wrote: With Workbooks("Y.xls") workbooks("X.xls").Worksheets("DEF").copy After:= _ .Worksheets(.worksheets.count) End With as an example. Both workbooks must be open. -- Regards, Tom Ogilvy "Stefan van der Hooft" wrote: Hi! I have a question about Excel tabs (worksheets) Is there a possibility to copy a tab-page (worksheet) from an Excel file to another Excel file. I know that it is possible within the same Excel file, but is it also possible to copy outside this file? Example: Sheet X with worksheet ABC DEF GHJ Sheet Y I want to copy DEF from worksheet X to sheet Y Kind regards, Stefan van der Hooft. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy 2007 excel file formula results into a 2003 Excel file | Excel Discussion (Misc queries) | |||
Copy Excel tab (worksheet) to another Excel file | Excel Worksheet Functions | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel |