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.