I was wondering as I am creating 100 excel sheets, (in 4 woorkbooks) with data and a chart (using a macro) is there anyway of saving the charts as a wmf file so I can use them in quarkexpress?
I am aware that one can save them to a cliboard but not sure if this helps in creating a wmf file.
any help would be gratefully appreciated.
Re: Saving a chart as a wmf
[code]
Set chtActive = ActiveSheet.ChartObjects(1).Chart
chtActive.Export "c:/test/" & strSheetName & ".wmf", "wmf"
[\code]
I've declared the chart as chtActive and I'm trying to call the wmf a name that I've saved as strSheetName but i get an error
Run time error 1004.
Method 'Export' of object'_chart' failed
any ideas why?
thanks for your comments so far.
Re: Saving a chart as a wmf
You haven't installed the image filter for the WMF file format.
To confirm this change the WMF to GIF and run the code.
Re: Saving a chart as a wmf
your absolutely correct. how do I install the wmf filter?
Re: Saving a chart as a wmf
You need to use your original Office disks and run setup to install filters.
Not sure whether Control Panel / Add+Remove programs might be another way to get the Office setup wizard going.
Re: Saving a chart as a wmf
Andy
Bets way is from teh Microsoft Original Office Disk[s] others way can work but messy - proper is always best - these additions can be made, as Jack always says when installing Office full install is always best unless like Jack you never use PowerPoint in such cases remove it from the install section from the office 2000 [same for all above versions] install dialog.
Note – always choose run from PC no other way.
Jack
Don’t have an account yet? Register yourself now and be a part of our community!
