| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy excel named ranges to powerpoint as pict with VBA
I have search several site for a couple of days and have not come up with the
code. Does any one have the code? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy excel named ranges to powerpoint as pict with VBA
I wrote a web page about working with PowerPoint and Excel:
http://peltiertech.com/Excel/XL_PPT.html This example on the page has, I think, what you want: http://peltiertech.com/Excel/XL_PPT.html#rangeppt - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Jeff" wrote in message ... I have search several site for a couple of days and have not come up with the code. Does any one have the code? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy excel named ranges to powerpoint as pict with VBA
Thanks I used your site and others to do what I need to do. but-- I have not been able to paste as a Picture I only get a table. This is my copy code and past code: PPApp.Visible = msoTrue Sheets("seac summary").Range("monthtomonth").Select Set PPSlide = PPApp.ActiveWindow.View.slide Selection.Copy PPSlide.Shapes.PasteSpecial(ppPasteMetafilePicture ).Select all help will be appreciated. "Jon Peltier" wrote: I wrote a web page about working with PowerPoint and Excel: http://peltiertech.com/Excel/XL_PPT.html This example on the page has, I think, what you want: http://peltiertech.com/Excel/XL_PPT.html#rangeppt - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Jeff" wrote in message ... I have search several site for a couple of days and have not come up with the code. Does any one have the code? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy excel named ranges to powerpoint as pict with VBA
The example I provided copied the range as a picture, so regular pasting
would paste as a picture. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Jeff" wrote in message ... Thanks I used your site and others to do what I need to do. but-- I have not been able to paste as a Picture I only get a table. This is my copy code and past code: PPApp.Visible = msoTrue Sheets("seac summary").Range("monthtomonth").Select Set PPSlide = PPApp.ActiveWindow.View.slide Selection.Copy PPSlide.Shapes.PasteSpecial(ppPasteMetafilePicture ).Select all help will be appreciated. "Jon Peltier" wrote: I wrote a web page about working with PowerPoint and Excel: http://peltiertech.com/Excel/XL_PPT.html This example on the page has, I think, what you want: http://peltiertech.com/Excel/XL_PPT.html#rangeppt - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Jeff" wrote in message ... I have search several site for a couple of days and have not come up with the code. Does any one have the code? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy excel named ranges to powerpoint as pict with VBA
Hi Jon - Thx for your website, i've found it very useful...the code seems to
work when i select less number of cell but if i try n select a slightly larger area i get this runtime error... "Excel cannot complete task with available resources, use lessd ata or close other applications" is there a way to avoid this ? "Jon Peltier" wrote: The example I provided copied the range as a picture, so regular pasting would paste as a picture. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Jeff" wrote in message ... Thanks I used your site and others to do what I need to do. but-- I have not been able to paste as a Picture I only get a table. This is my copy code and past code: PPApp.Visible = msoTrue Sheets("seac summary").Range("monthtomonth").Select Set PPSlide = PPApp.ActiveWindow.View.slide Selection.Copy PPSlide.Shapes.PasteSpecial(ppPasteMetafilePicture ).Select all help will be appreciated. "Jon Peltier" wrote: I wrote a web page about working with PowerPoint and Excel: http://peltiertech.com/Excel/XL_PPT.html This example on the page has, I think, what you want: http://peltiertech.com/Excel/XL_PPT.html#rangeppt - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Jeff" wrote in message ... I have search several site for a couple of days and have not come up with the code. Does any one have the code? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named ranges scope / workbook/worksheet level named ranges- changeswith variable use... | Excel Programming | |||
| Copy and paste Named Ranges | Excel Programming | |||
| How do I copy a group of worksheets with named ranges in Excel 200 | Excel Worksheet Functions | |||
| Copy data in named ranges to a newer version of the same template to identical ranges | Excel Programming | |||
| copy named range to powerpoint | Excel Worksheet Functions | |||
Hybrid Mode
