Hi,
I'm looking for help in exporting multiple tables and charts to Excel.
I have a workbook called ABC.xls and a document called ABC.doc in the same folder.
In ABC.xls, I have an index page and several (could vary) worksheets. Each sheet has either a 1 Table or 1 Chart or both in it.
I need to export all of these tables/charts to ABC.doc, and if possible under a heading (worksheet.name).
There are some other things such as bookmarking and formatting but I'm confident i can do this, it's just the excel - word integration that I'm stuck with.
Many thanks
I'm looking for help in exporting multiple tables and charts to Excel.
I have a workbook called ABC.xls and a document called ABC.doc in the same folder.
In ABC.xls, I have an index page and several (could vary) worksheets. Each sheet has either a 1 Table or 1 Chart or both in it.
I need to export all of these tables/charts to ABC.doc, and if possible under a heading (worksheet.name).
There are some other things such as bookmarking and formatting but I'm confident i can do this, it's just the excel - word integration that I'm stuck with.
Many thanks