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
|