Paste excel object in PPT

G2K

Active Member
Joined
May 29, 2009
Messages
355
Hi All,

i want a macro to copy a particualr worksheet range say (A2:h20) and paste this to powerpoint presentation slide. i need to update the ppt on daily basis. the sorce and destination will remain same and the object need to pasted on slide no 11.

any help would be apriciated.

thanks in advance
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

adminfunwn

New Member
Joined
Nov 3, 2009
Messages
18
You can make tables and graphs inside PowerPoint—but don’t. Don’t even use the Insert, Table, Excel spreadsheet choice. These functions do not work well.
Instead, just open Excel and make your chart or table there. Select the chart or table, copy, and paste into PowerPoint. Voila.
Here’s the magic. If you create a chart in Excel, then paste it into PowerPoint, PPT will automatically adjust the chart style to match the presentation theme. So if you copy this chart in Excel:
Tables do not automatically reformat, but you can easily change them by selecting the table after you paste it into PowerPoint, and then using one of the Quick Styles available from the Table Tools, Design ribbon. For example—the table shown in the slide above looked like this when originally copied in Excel:
 

Watch MrExcel Video

Forum statistics

Threads
1,118,574
Messages
5,573,009
Members
412,495
Latest member
CoolerOconnor
Top