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.

Yes, the other workbook needs to be open, right click the sheet tab, from
the top dropdown select the workbook, from the lower select where in the
workbook and finally check create a copy unless you want to move the sheet
altogether

--
Regards,

Peo Sjoblom

"Stefan van der Hooft" wrote
in message ...
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.

You need to have both workbooks open in the same Excel instance so that you
can do this.

When you copy the tab, change the "To Book" option on the Move or Copy
screen.

"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.

Dear Barb and Peo,

Thank you both 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 option?

Kind regards, Stefan van der Hooft




"Peo Sjoblom" wrote:

Yes, the other workbook needs to be open, right click the sheet tab, from
the top dropdown select the workbook, from the lower select where in the
workbook and finally check create a copy unless you want to move the sheet
altogether

--
Regards,

Peo Sjoblom

"Stefan van der Hooft" wrote
in message ...
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.

Stefan

See Ron de Bruin's site

http://www.rondebruin.nl/tips.htm

Browse through the section on Copy/Paste/Merge examples


Gord Dibben MS Excel MVP


On Tue, 3 Apr 2007 13:34:01 -0700, Stefan van der Hooft
wrote:

Dear Barb and Peo,

Thank you both 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 option?

Kind regards, Stefan van der Hooft




"Peo Sjoblom" wrote:

Yes, the other workbook needs to be open, right click the sheet tab, from
the top dropdown select the workbook, from the lower select where in the
workbook and finally check create a copy unless you want to move the sheet
altogether

--
Regards,

Peo Sjoblom

"Stefan van der Hooft" wrote
in message ...
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.