Excel export chart to wmf or emf?

I am trying to export a chart from Excel to either the wmf or emf format.

The code works if you export to GIF but not with WMF as the filtername.

This works:

Chart.Export FileName:="current_sales.gif", FilterName:="GIF"
But

Chart.Export FileName:="current_sales.wmf", FilterName:="WMF"
fails giving the error:

Run-time error '1004': Application-defined or object-defined error

Powerpoint allows you to export to WMF. And I have "successfully" exported by copying the graph into Powerpoint and having Powerpoint export the image to WMF but there has to be an easier way - I hope.



Please help! Thanks.