vba error 1004 when upgrading from excel 2000 to 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Mark

Try taking the "" from around the FALSE. Maybe the issue

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
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.
 
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
 
Back
Top