Run-time error '1004'; Method 'Export' of object'_Chart' failed

[Father Guido]

When I run my macro in XL2003, I get the following Run-time error
message 'Run-time error '1004'; Method 'Export' of object'_Chart'
failed' everytime the macro runs the following line.

ActiveChart.Export Filename:=LCase(SaveName), _
FilterName:="GIF"

Anyone have any suggestions? What is the error really trying to tell
me?

Thanks,

Norm

 

[Dave Peterson]

My first guess would be that SaveName wasn't valid.

 

[Father Guido]

On Thu, 24 Nov 2005 10:20:51 -0600, Dave Peterson

~My first guess would be that SaveName wasn't valid.

+-----------------------------------------------------------------+
| You know what? You're right, I finally got it working -- the |
| darned file name had a typo in it that I just couldn't see for |
| the forest. Much apologies to all, and thank you all for your |
| help over the last several days. |
| |
| Norm |
+-----------------------------------------------------------------+

~Father Guido wrote:
~>
~> When I run my macro in XL2003, I get the following Run-time error
~> message 'Run-time error '1004'; Method 'Export' of object'_Chart'
~> failed' everytime the macro runs the following line.
~>
~> ActiveChart.Export Filename:=LCase(SaveName), _
~> FilterName:="GIF"
~>
~> Anyone have any suggestions? What is the error really trying to
tell
~> me?
~>
~> Thanks,
~>
~> Norm

 

[Dave Peterson]

Gawd, I hate those!

On Thu, 24 Nov 2005 10:20:51 -0600, Dave Peterson

~My first guess would be that SaveName wasn't valid.

+-----------------------------------------------------------------+
| You know what? You're right, I finally got it working -- the |
| darned file name had a typo in it that I just couldn't see for |
| the forest. Much apologies to all, and thank you all for your |
| help over the last several days. |
| |
| Norm |
+-----------------------------------------------------------------+

~Father Guido wrote:
~>
~> When I run my macro in XL2003, I get the following Run-time error
~> message 'Run-time error '1004'; Method 'Export' of object'_Chart'
~> failed' everytime the macro runs the following line.
~>
~> ActiveChart.Export Filename:=LCase(SaveName), _
~> FilterName:="GIF"
~>
~> Anyone have any suggestions? What is the error really trying to
tell
~> me?
~>
~> Thanks,
~>
~> Norm