Copy Sheet

[John Mamani]

Good Morning all

We are using MS Excel 2002

Using VBA Code, is there a way to copy a single entire sheet from a diferent
workseet?

Regards,

Bre-x

 

[JLGWhiz]

This from VBA help file. Creates a new sheet and copies.

Worksheets("Sheet1").Copy After:=Worksheets("Sheet3")

If you want to copy from Sheet 1 to Sheet 2

Worksheets(1).Cells.Copy Worksheets(2).Range("A1")

 

[John Mamani]

Hi,
Thank you for you quick answer.

This is to copy sheet between the same worksheet right?

We need to copy sheets from another worksheet.

 

[JLGWhiz]

The first one copies a worksheet, creates a new worksheet in the same
workbook with the data from to copied worksheet.

The second one copies the data in a worksheet to an existing worksheet in
the same workbook.

For more information, see this website.

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

 

[John Mamani]

I didnt explain myself well.
Here is what I was looking for:

Sheets.Add Type:= _
"F:\1CNC\APPS\EXCEL\template_01.xls"

Thank you all for you help