slide

Hi all, I need a little help on some automation work Im currently looking at. The work at a high level is: Data table in Excel is moved row by row into a table on a PowerPoint slide. All the code to open PPT move data format etc is in place but I am struggling with one element: When pasting...

Hi, I've created a macro which selects cells, sorts by one column high to low, then selects a range of cells, pastes in a different cell as a picture, names that picture, then opens powerpoint, selects a slide then, selects the named picture and pastes into position on the slide. This is then...

Hi, I have a macro that copies a variable range in excel and pastes it as a picture into powerpoint. I would like to change the code so the picture is aligned centre and middle and then resized (keeping it's ratio) to occupy a the majority of the slide (eg. 75% of the slide size which gives me...

I am trying to create a macro in powerpoint to automate some regular tasks. So, I have a master powerpoint that has ~60 odd slides. I want to create a macro that will go through the entire deck and copy specific slides that have certain text in them. I can create an array with the key words that...

Hi all, I am currently pasting data into certain Powerpoint tables from certain cells using VBA The common factor is that a row of data gets pasted into a single slide (i.e. Row 3 in excel then is pasted into Slide 2). At which point they all increase by 1 (row 4 into slide 3 etc.) I have...

Building a PowerPoint presentation from Excel. PowerPoint and the file open properly and it fails when selecting the PowerPoint Slide. Feel free to comment on other coding adjustments you feel need cleaning up. Sub OpenPPTPresent() 'Opens a PowerPoint Document from Excel Dim PPT As...

Hi, I want after I select slide, copy there charts from excel, I have code as below: Set wb = ActiveWorkbook Set ws2 = wb.Worksheets("C2") Dim newPowerPoint As PowerPoint.Application Dim activeSlide As PowerPoint.Slide Dim cht As Excel.ChartObject Set newPowerPoint = New...

Hi, I'm adding empty slide. Then I want to set Template (slide 6 from 4x3_Cool_Template.potx). But I dont know how to use it? newPowerPoint.ActivePresentation.Slides.Add newPowerPoint.ActivePresentation.Slides.Count + 1, ppLayoutBlanknewPowerPoint.ActiveWindow.View.GotoSlide...

hi all, i already have an excel file having some tables.. i also have a powerpoint slides which has these tables. i want the heading that i have given in my excel for each table to the be the heading of the powerpoint slide. Have been searching a lot of threads online but not able to get a...

Hi All,</SPAN> I am trying to get a sign up sheet embedded onto the end of a powerpoint presentation. There are four textboxes - Forename, Surname, Email and network id that the user can enter information.</SPAN> I need that information to populate cells in Excel for e.g the header line...