Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to generate powerpoint slides
I started a thread in the MS EXCEL and VBA MACROS group. My post in
their group has a sample folder with all necessary files. here is a link to test and play with it. Thanks. https://groups.google.com/forum/#!to...os/-ZintzqwKD8 Got it working with the followig code... Option Explicit Sub CreatePPT() Dim vList, n&, oPres vList = ActiveSheet.Range("A1:A5") On Error GoTo Cleanup 'Automate a new instance of PowerPoint ' Set appPPT = CreateObject("PowerPoint.Application") With CreateObject("PowerPoint.Application") 'appPPT 'Add a new presentation Set oPres = .Presentations.Add With oPres.slides 'Insert the slides into the presentation For n = LBound(vList) To UBound(vList) .InsertFromFile vList(n, 1), .Count Next 'n End With 'oPres.slides .Visible = True End With 'CreateObject Cleanup: Set oPres = Nothing End Sub -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Powerpoint slides from Excel pages | Excel Discussion (Misc queries) | |||
where do u get slides for microsoft powerpoint 2003? | Excel Discussion (Misc queries) | |||
Powerpoint slides to be used in excel macros | Excel Discussion (Misc queries) | |||
Excel formulas on different Powerpoint Slides | Excel Worksheet Functions | |||
Generate powerpoint slides from excel automatically | Excel Programming |