View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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