PC Review


Reply
Thread Tools Rate Thread

Copypicture from Excel to PowerPoint

 
 
MatsN
Guest
Posts: n/a
 
      6th Apr 2010
Hi,
In a VBA routine a selected ranges in Excel (2003) is copied and paste in
PowerPoint. The routine runs a loop with an number of entities.
A number of rows and columns in the selected area are grouped on a lower
level and only cells on level1 are visiblebefore CopyPicture.It works OK
apart from one problem. The problems is that some of the columns, furthest to
the right, are not included in the PowerPoint shape.
It can vary a little some what which user runs the routine.
Below extract from the code.
Thanks in advance for any help.

"Worksheets("Forecast Report").Range(Cells(11, 25), Cells(53, 51)).CopyPicture
pptapp.Activate
pptapp.Presentations(ppfilename).Slides(pp2).Shapes.Paste
shn = pptapp.Presentations(ppfilename).Slides(pp2).Shapes.Count
ppheigt = 320
Set Shape4 = pptapp.Presentations(ppfilename).Slides(pp2).Shapes(shn)
With Shape4
.Name = compl & ppcur & "shapetable"
.Top = 75
.Left = 20
.Height = ppheigt
End With "



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
CopyPicture from Excel Range to Power Point MatsN Microsoft Excel Programming 0 21st Mar 2010 04:10 PM
CopyPicture ????? Paul Smith Microsoft Excel Charting 3 15th Feb 2005 10:49 PM
CopyPicture Colors to PowerPoint Ben Microsoft Excel Charting 1 22nd Nov 2004 05:35 AM
Excel CopyPicture and PowerPoint Bo Microsoft Excel Charting 7 28th Apr 2004 02:18 PM
CopyPicture Remi Microsoft Excel Programming 8 13th Nov 2003 02:13 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:34 AM.