Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copypicture from Excel to PowerPoint
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).Shape s.Paste shn = pptapp.Presentations(ppfilename).Slides(pp2).Shape s.Count ppheigt = 320 Set Shape4 = pptapp.Presentations(ppfilename).Slides(pp2).Shape s(shn) With Shape4 .Name = compl & ppcur & "shapetable" .Top = 75 .Left = 20 .Height = ppheigt End With " |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copypicture from Excel to PowerPoint
Is the power point object a picture or an excel object? Have you check is the picture is croped or the excel object isn't display all the columns? Double click the Power Point Object and see if you can tell what is happening. You may want to changge the Paste to PasteSpecial so you can select the type of object that is savgved in Power Point. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=193267 http://www.thecodecage.com/forumz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CopyPicture from Excel Range to Power Point | Excel Programming | |||
Range CopyPicture() | Charts and Charting in Excel | |||
CopyPicture ????? | Charts and Charting in Excel | |||
CopyPicture ????? | Excel Programming | |||
CopyPicture | Excel Programming |