export chart as wmf

B

b

I have a chart which I am attempting to export as an image but it is not
working, it exports as png, gif, jpg, but not wmf. Here is the code:

Dim c As Chart

Set c = Worksheets(1).ChartObjects(1).Chart

c.Export "C:\tmp\chart1.wmf", "WMF"

I have downloaded the graphic filter WMFIMP32.FLT and saved it to C:\Program
Files\Common Files\Microsoft Shared\GRPHFLT , but it still doesn't work.

Any ideas?

thanks
 
J

Jon Peltier

Chart.Export only works with selected raster formats (bmp, jpg, gif, png,
tif), but not vector formats. You could paste the chart into PowerPoint as a
graphic, then save it as a metafile using PowerPoint. I don't have code
handy to do this.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top