Copying sheet to another workbook using VBA...

T

Trevor

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
 
N

Norman Jones

Hi Trevor,

Try something like:

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