tags:

views:

20

answers:

0
Q: 

How to copy cell range as table from excel to powerpoint - VBA

I cant find any way to do this. What I have now is that it copy the range as an image:

Dim XLApp As Excel.Application Dim PPSlide As Slide Set XLApp = GetObject(, "Excel.Application") XLApp.Range("A1:B17").Select XLApp.Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture

PPSlide.Shapes.Paste.Select

this works like a charm, but is it possible to get it to copy the range as a table instead of picture?

related questions

Creating powerpoint presentations programmatically
An automated way to load multiple images into PowerPoint on different pages?
Running PowerpointViewer.exe inside a .Net form
How to do a presentation for your co-workers containing lots of code?
Displaying Powerpoint slides on second monitor non-sequentially using VBScript
Generating Powerpoint PPT with Coldfusion?
asp.net - Generate Powerpoint file on the fly
Defining macros in Power Point 2007?
Linking Powerpoint and Access through VBA?
Can Silverlight apps be embedded into PowerPoint?
Export from PowerPoint to animated gif?
How do I capture a PowerPoint VSTO Text Changed Event?
Best way to make a newsletter slideshow kiosk for the office?
Using C# to display powerpoint
PowerPoint - How can I figure out if a presentation has a password progamatically?
Renaming Objects in PowerPoint
VBA in PowerPoint
Editing Embedded PowerPoint from Excel VBA
Win32 ShellExecute and a UNC Path
ISmartTagAction::Action Target is null with PowerPoint
Tools for manipulating PowerPoint files
MS Access Reporting - can it be pretty?
Embed Powerpoint into HTML
Technical Presentations - Can the slides work without bulleted lists?
how to hyperlink to a specific slide of a .ppt file