Export Charts from Word 2007 using VBA

[kmohankumar]

Hi,

I would like to know if there is a way to export the charts created in Word 2007 and save the charts as an excel file.

Thanks,
Mohan

[mdmackillop]

Welcome to VBAX
No idea! Can you post a sample? Use Manage Attachments in the Go Advanced section. You'll have to Zip your file.
Regards
MD

[kmohankumar]

Hi MD,

Thanks for your reply. I have attached the word document which contains charts (4 charts). I would like to save down these embedded charts as an excel file.

Let me know if this is possible.

Thanks,
Mohan

[TonyJollans]

Unfortunately, no!

It seems they forgot to include VBA access to the new charts in Word 2007 (and also PowerPoint, I think) - and the OM is severely lacking even in Excel.