paste range (excel) as table to powerpoint

Microsoft Office excel 2007 home & stude...
August 19, 2010 at 04:45:06
Specs: Windows 7
Please help,
I need macro which can copy selected range of excel worksheet to powerpoint presentation as table. I found many examples how to copy range as picture to powerpoint, but I need to copy it as table.

See More: paste range (excel) as table to powerpoint

Report •

August 19, 2010 at 06:29:25

Why do you need a macro to do this.

Copy a range of cells in Excel.

In PP with a new Title-only slide, select 'Paste Special' and choose 'Microsoft Office Excel Worksheet Object' from the list. Select Paste (or Paste Link if you want the cells to continue to change if the source cells in the Excel workbook change), and click OK.

You now have an embedded Excel range of cells which can be edited like any Excel range.


Report •

August 20, 2010 at 16:00:29
Because I have 80 charts and tables every month to copy like that and my boss wants me to write a macro to do it in a way that I wrote above.

Report •

Related Solutions

Ask Question