vba error 1004 when upgrading from excel 2000 to 2003

M

Mark Holcomb

I have working vba code from excel 2000 but chokes in 2003. The debugger
points to the second line (i put the first one in for context) ... the help
suggests some sort of 'on error' statement which I dont used.

Set co1 = Worksheets("Position solution - 2act ").ChartObjects("Chart
1221")
co1.Chart.Export Filename:="C:\chart1.gif", FilterName:="GIF",
Interactive:="FALSE"

does anyone know what has changed? why this doesnt work?

Thanks!
MarkH
 
M

Mark HOlcomb

I will try that... my home computer is upgraded to Office SP1 while my work
computer is not .. it works at home but not at work .. hmmmm.
 
M

Mark HOlcomb

The only other difference is the same code works in
windows XP SP2 and Office 2003 SP1
but does not work in
windows 2000 pro and Office 2003 SP1
 
Top