Thread
:
Chart Export Issues
View Single Post
#
3
Posted to microsoft.public.excel.programming
Andy Pope
external usenet poster
Posts: 2,489
Chart Export Issues
Hi,
Are you sure you have the appropriate graphic filters loaded?
You can check using Control panel Add/Remove Programs and changing the
Office settings. for xl2003 at least they are in the Office Shared
Features Converters and Filters Graphic Filters.
Cheers
Andy
wrote:
This is a problem I've dealt with for some time. I try to use this
code to export a chart as a GIF file and from the postings I've read,
there have been no problems. However, everytime I try to run this it
gives me a Run Time error '1004' and I cannot figure out why. The
exact code as is below.
Fname = ThisWorkbook.Path & Application.PathSeparator & "Chart.gif"
Worksheets("Charts").ChartObjects(1).chart.Export Filename:=Fname,
FilterName:="GIF"
The two things I notice are that
VB
automatically puts a lowercase C on
chart and a lowercase N on Filename - I don't know what this indicates.
The Export function is in my object browser so it must be loaded in -
but it does not work.
What am I missing?
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply With Quote
Andy Pope
View Public Profile
Find all posts by Andy Pope