Macro to copy one worksheet to another

[tarantula]

I have a word macro that copies all the data from the active worksheet
and pastes it in a different excel workbook based on a template.I used
the following code:

sheets(1).Copy Before=Workbooks(WkbName).Sheets(1)


But it results in a new worksheet being inserted in the Workbook
WkbName..which i dont want.i want the data to be copied to the first
sheet of the workbook 'WkName'

Please Help!!
its urgent...

 

[Simon Lloyd]

Sheets(1).Copy copies the first sheet as a whole sheet, really you need
to copy the data and paste it to the first sheet.

I have a word macro that copies all the data from the active worksheet
and pastes it in a different excel workbook based on a template.I used
the following code:

sheets(1).Copy Before=Workbooks(WkbName).Sheets(1)


But it results in a new worksheet being inserted in the Workbook
WkbName..which i dont want.i want the data to be copied to the first
sheet of the workbook 'WkName'

Please Help!!
its urgent...

--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[jax]

Sheets(1).Copy copies the first sheet as a whole sheet, really you need
to copy the data and paste it to the first sheet.






--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

try this

Sheets("name").Select
Sheets("name").copy
Workbooks.Add
ActiveSheet.Paste
Application.CutCopyMode = False

Jagdish Bisht ([email protected])