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
 
N

Nick Hodge

Mark

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime Error 1004 1
Programatically Export Excel Chart to Graphic in SharePoint 5
Chart.Export error '1004' after upgrade to Excel 2003 0
Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error; 5
export filter - programmatic access to 0
export chart method error - excel2003 4
[Excel 2003] Exporting Diagram as Bitmap with VBA 2
Excel 2003 - VBA Code Problem 4

Top