Copying sheet to another workbook using VBA...
 

Hello All,

I have a macro that executes some functions and I want to,
at the end, save the current sheet as a sheet on another
existing workbook. Can someone help with this? I would
appreciate it.

Trevor

Copying sheet to another workbook using VBA...
 

Hi Trevor,

Try something like:

ActiveSheet.Copy After:= _
Workbooks("OtherWorkbook.xls").Sheets("Sheet2")


---
Regards,
Norman



"Trevor" wrote in message
...
Hello All,

I have a macro that executes some functions and I want to,
at the end, save the current sheet as a sheet on another
existing workbook. Can someone help with this? I would
appreciate it.

Trevor