AnsweredAssumed Answered

vrf ActiveX Excel Chart Copy

Question asked by VRFuser on Mar 14, 2006
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

Outcomes