Copy content of 1 sheet to another one

M

Maileen

Hi,

I use VBA and excel 2003. I would like via VBA, copy the content of 1 sheet in
the file "test.xls" to a sheet in the file "filedesti.xls".

I tried :

workbook("test.xls").sheet(1).copy workbook("filedesti.xls").sheet(1)

but it does not work correctly.
suddenly, my CPU is used a 100% and Excel process use more than 182 Mb of memory
for this task, whereas my file "test.xls" is no more than 4.4 Mb.

could you help me please ?
thanks a lot,
maileen
 
A

Ardus Petus

Your code produces en error on my box. You should use "Sheets" instead of
"Sheet"

HTH
 
M

Maileen

Sorry, it's a mistake when i copy my code...for sure i used "Sheets" instead
of "Sheet"
 
Top