I am very new to VBA and I need help with copying a chart from one workbook to another. The problem is that in the workbook I am copying from, the chart is a separate page. However, I want to copy just the chart and not have it be an entire page. Here is the code I am using:

VB Code:
  1. DataBook.Sheets("Heat Transfer").Copy After:=OutputBook.Sheets(1)
VB Code:
  1. DataBook.Sheets("Heat Flux").Copy After:=OutputBook.Sheets(2)
Code:
DataBook.Sheets("Skin Temperature").Copy After:=OutputBook.Sheets(3)
I think I am transfering the code into this message the right way but if it is awkward, I am sorry.

Thanks for any help, it will be appreciated
-Robert