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

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

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

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

~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

Gawd, I hate those!

Father Guido wrote:

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

~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