PDA

View Full Version : Need a Macro that Copies cells (Tables) and charts from Excel and Pastes to Word



vaso81
04-18-2012, 01:31 PM
I have been unsuccessfully trying to develop a macro that copies cells (tables) and charts in Excel and pastes them to a Word file in designated places. I am trying to automate importing tables and charts from an Excel file to a report in Word.

I would be grateful for any assistance.

I am attaching an excel file ("Compiler"). I would like to copy the table from sheet1 and the chart from sheet2 to a word file.

I would like the table and the chart to be pasted a word file under figure1 and figure2 captions.

Thank you in advance!

Vaso