Run-time error '1004'; Method 'Export' of object'_Chart' failed
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
|