View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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