Copy excel sheet to another excel file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zurn - 13 Jan 2006 16:36 GMT

What code will help me with copying an excel sheet to another ecel file.

I open two excel files with code in Access environment.

Now I want values from one sheet to another (Pastespecial only the values)...

Where can I find info about this matter?

Thx,
Zurn

Reply to this Message

SteveS - 14 Jan 2006 17:50 GMT

Zurn,

You should ask your question in one of the Excel newsgroups.

This newsgroup is for the Access database.

HTH

Signature

Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)

> What code will help me with copying an excel sheet to another ecel file.
>
[quoted text clipped - 6 lines]
> Thx,
> Zurn

Reply to this Message

Ed Adamthwaite - 16 Jan 2006 06:12 GMT

Hi Zurn,
if you want to copy before a sheet in the destination Excel file:

xlApp.Sheets("Sheet1").Copy
Workbooks("MyOtherWorkBook.xls").Sheets(1)

if you want to copy after a sheet in the destination Excel file (notice the
comma):

xlApp.Sheets("Sheet1").Copy ,
Workbooks("MyOtherWorkBook.xls").Sheets(1)

I assume that you have something like "xlApp" as the object variable for the
Excel.Application.

HTH, :-)

Ed Adamthwaite

> What code will help me with copying an excel sheet to another ecel file.
>
[quoted text clipped - 7 lines]
> Thx,
> Zurn

Reply to this Message

Zurn - 16 Jan 2006 08:58 GMT

I did not want a new sheet, I copied the values to the "source" sheet of the
new excel file. Your code was very helpful. Thank you

xlApp.Sheets(1).cells.Copy
xlApp.Workbooks("accessDB.xls").Sheets("source").cells

*Zurn*

> Hi Zurn,
> if you want to copy before a sheet in the destination Excel file:
[quoted text clipped - 26 lines]
> > Thx,
> > Zurn

Reply to this Message