I am importing Word charts into Excel. I found the macro below which loops through a Word document and imports all charts. However, it added them all on one sheet, and I need each chart on a separate sheet. So I tried adding the
line, and although that puts each chart on a separate sheet, it does not put the chart at the top of the sheet, but several rows down.
Is there a way to have the chart start at the top of the excel sheet? Here is the test .doc file I'm working with. Test.doc
I am on a Mac, using 2010. Thanks!
Bookmarks