I am trying to copy a embedded chart from Excel and pasting it to Word. I recorded the following macro in Excel and pasted it into VEE. I get the error message that "Variable was not found: ActiveSheet". I have the Microsoft Office Excel 9.0 Object Library selected under ActiveX Automation References. What am I missing?
ActiveSheet.ChartObjects("Chart 1").Activate;
ActiveChart.ChartArea.Select;
ActiveChart.ChartArea.Copy
Jim Dykema
GENERAL DYNAMICS
8201 E. McDowell Rd.
Scottsdale, AZ 85257
Phone: (480) 675-2104
FAX: (480) 441-3625
Pager Numeric: (877) 526-7062
Pager Text: 8775267062@skytel.com
Email: jim.dykema@gdc4s.com
ActiveSheet.ChartObjects("Chart 1").Activate;
ActiveChart.ChartArea.Select;
ActiveChart.ChartArea.Copy
Jim Dykema
GENERAL DYNAMICS
8201 E. McDowell Rd.
Scottsdale, AZ 85257
Phone: (480) 675-2104
FAX: (480) 441-3625
Pager Numeric: (877) 526-7062
Pager Text: 8775267062@skytel.com
Email: jim.dykema@gdc4s.com