I have a problem with a PDF created from a Word 2007 doc that contains an Excel chart pasted special as 'Picture (Enhanced Metafile)' so a Googling I did go and found this code: http://peltiertech.com/WordPress/enhanc ... procedure/
Worth a try, thinks I. However when I paste it into a Module and try to run it, Excel objects at the line:
The code uses some auxiliary routines from the File Name Functions page. You should copy the code from that page into the same module or into a separate module in the same workbook.
Also, there is an idiot version (i.e. an .xla in a zip file) at the very bottom of the page. The add-in works except the .png it created looked nothing like my chart!
Another option is to save the workbook as a web page (*.htm, *.html). This will create a subfolder in the folder containing the .htm(l) file with a low and high quality version of the charts in the workbook.
Initially it too looked nothing like my original chart but my default image file view is IrfanView. If I 'open with' and use Windows picture & fax viewer the graphic looks as I expected it. Perhaps this is an IrfanView 'issue' but I've not got time to experiment further right now.