Copy Excel tab (worksheet) to another Excel file

[Guest]

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.

 

[Guest]

With Workbooks("Y.xls")
workbooks("X.xls").Worksheets("DEF").copy After:= _
.Worksheets(.worksheets.count)
End With

as an example. Both workbooks must be open.

 

[Guest]

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