+ Reply to Thread
Results 1 to 2 of 2

Need vba code to export dashboard range as ppt slide

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Need vba code to export dashboard range as ppt slide

    hi experts

    I have excel dashboard i want export to ppt by single click

    i have segregate as set of range for ppt slide,

    small table and chart as one slide-1
    another table1 and table2 is another slide.-2
    small table and chart as one slide-3
    another table3 and table4 is another slide.-4
    small table and chart as one slide-5
    another table5 and table6 is another slide.-6
    small table and chart as one slide-7
    another table7 and table8 is another slide.-8
    big table_1 slide-9
    big table_1 slide-10.


    thanks find the attachment
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: Need vba code to export dashboard range as ppt slide

    Found code help on this with this screnio

    
    Sub GetExcelDataInYourPresentation()
         
        'Declaration
        Dim PptApp As PowerPoint.Application
        Dim PptDoc As PowerPoint.Presentation
         
        'Initialisation
        Set PptApp = CreateObject("Powerpoint.Application")
        PptApp.Visible = True
        Set PptDoc = PptApp.Presentations.Open("C:\Finance_Pres.ppt")
      
        With PptDoc
            'copy cells from the Excel sheet
            Feuil1.Range("B1:H5").Copy
            'Paste in the slide
            .Slides(2).Shapes.Paste
        End With
         
       'Layout
        With PptDoc.Slides(2).Shapes(.Slides(2).Shapes.Count)
            .Name = "Weather" 'Rename the table pasted
            .Left = 150 'Horizontal position in the slide
            .Top = 100 'Vertical position in the slide
            .Height = 300 'Height
            .Width = 400 'Width
        End With
      
        'Insert cell A1 in the text zone of the slide 4
        PptDoc.Slides(4).Shapes(2).TextFrame.TextRange.Text = Range("A1").Value2
      
        'Free variables
        Set PptDoc = Nothing
        Set PptApp = Nothing
     
    End Sub
    Last edited by breadwinner; 12-03-2022 at 08:06 PM. Reason: help on code

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Export video with zoom slide
    By Undo in forum PowerPoint Formatting & General
    Replies: 0
    Last Post: 01-30-2022, 11:24 PM
  2. VBA code to pull charts from seperate worksheets to a dashboard to fit a specific range
    By Matt Jennings in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-06-2019, 12:39 PM
  3. Replies: 0
    Last Post: 07-18-2019, 07:43 AM
  4. Replies: 0
    Last Post: 05-02-2017, 07:10 AM
  5. Inserting Slides from Another Presentation Removes Slide Numbering & Footer on Slide
    By PSSMargaret in forum PowerPoint Formatting & General
    Replies: 2
    Last Post: 05-15-2016, 09:21 AM
  6. [SOLVED] VBA Code to Export a Set Range of Cells as CSV
    By PatCell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2015, 01:43 PM
  7. Replies: 1
    Last Post: 04-02-2012, 03:57 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1