slide

  1. S

    [VBA] Opening an existing Presentation File from Excel and adding new slide in a for loop

    I have a macro here that works fine when creating a new presentation, but now I have a specific layout that I need to use from an existing presentation . So I was thinking I could open the presentation and add a new slide for every loop. I tried the getobject method but kept running into an...
  2. M

    Creating a Powerpoint Based on Excel Data

    Hi All, I'm after a macro that will loop through all the rows in column A on an excel spreadsheet and create a powerpoint slide for each one and put the value from the cell on the slide and insert an image according to a specified filepath in column B. E.g. Create a slide tittle "Apple" from...
  3. S

    copy a slide of a powerpoint presentation in Excel/VBA

    Hi, Im trying to copy a slide in a ppt using the following code: Sub openppt() Dim PowerPointApp As PowerPoint.Application Set PowerPointApp = CreateObject("PowerPoint.Application") PowerPointApp.Presentations.Open ("C:\test\template.pptx")...
  4. C

    Latest version of Excel/PowerPoint

    Is it possible to link data from a Excel spreadsheet into a LIVE PowerPoint slide? So if I have PowerPoint running in Slide Show mode, is it possible (without any macros or VBA) to have another person updating a shared excel spreadsheet and have that data update instantly within my live...
  5. L

    excel vba to copy powerpoint object between presentations

    Good Morning, One of my bosses stared an excel file tat cud be used to copy slide objects from one presentation to another one. Currently something is not working right so i though i would come here to see if anyone has done this before. Currently i have one excel file that has the capability...
  6. S

    VBA Msgbox code not working

    Hey all, sorry to post to the wrong board but i am new here and could not find a thread about PowerPoint. With that being said I am trying to have a msgbox appear when the powerpoint file is opened, and then when the user decides to go to a next slide I want the same macro/msgbox to re-appear...
  7. S

    Combobox VBA in PowerPoint

    Hi all, I know this is technically an Excel forum but wasn't too sure where else to post this. Essentially I am trying to create a drop-down navigation tool Combobox for all the slides I have on my PowerPoint so users can jump around the presentation no matter which slide they are on. I have...
  8. T

    Embedding in Excel

    Hello... I need to embed an individual Powerpoint slide in to an Excel cell. I have searched trying to figure out how to do it and can't seem to embed just an individual slide. Is this even possible? I figured I would just come here and ask the professionals...can anyone please HELP?
  9. J

    Excel VBA to create/duplicate powerpoint slides and replace text/photos

    Hi All, I have to produce a large power point presentation for our Xmas party with all of our compliments for the year. I have over 1200 entries on an excel spreadsheet and have been trying to write/research the code to convert this in to a powerpoint presentation but I'm struggling so far...
  10. R

    method activate of object chartdata failed

    Hi, I have below macro to update the graphs automatically from Excel to PPT. i was run normally using old laptop, now i upgraded the laptop, and when i ran it showed error "method activate of object chartdata failed" can you please help whats wrong with it ? below the macro Sub UpdateAll()...
  11. K

    VBA Code Run Time Error on Excel to Powerpoint

    Okay. i have been using the attached code for some time without issues in my files. However, within the past few days, I have been getting a run time error that is very random in its appearance. The code below is simplified to create two slides in PowerPoint, where one Excel table becomes one...
  12. N

    VBA - Inconsistent PPT Formatting Across Computers

    I have automated the creation of a PPT slide. However, the issue I run into arises when I run it on other computers. The size and positioning of the shapes seems to change ever so slightly, but noticeably. I have the shapes set to position themselves automatically based on original position...
  13. A

    Apply one macro to specific chart on several slides

    Dear Community, On the last days I have tried to develop the following: I have a PPT presentation with a specific amount of slides. Starting from the second slide I have pasted excel tables directly linked to the file (paste special). Sometimes I have been facing the issue that after updating...
  14. M

    Crop Image via VBA in PowerPoint

    Hi, I am using the code: <!-- BEGIN TEMPLATE: bbcode_code --> <code>ppApp.ActiveWindow.Selection.ShapeRange.PictureFormat.CropRight = 10</code> <!-- END TEMPLATE: bbcode_code -->to crop the image on the slide, however it gives the possibility to crop by fixed size (10). Is it possible...
  15. M

    VBA Copy Pictures from Excel and Paste them in PowerPoint

    Hi Guys, how is everything? I have excel sheet contains 3 pictures, Picture1, Picture2 and Picture3. How to write VBA code to open specific existing PowerPoint file, delete any pictures in this PowerPoint file first, and then to copy Picture1 and paste in slide 2, Picture2 in slide 5 and...
  16. F

    Linked excel workbooks to powerpoint, linking cells

    Hello, The situation: I have power point file which has 2 slides, if I understand correctly each slide is linked with seperate excel WORKBOOKS. When you select lets say first slide and tap 2 times on content excel workbook appears, then You can enter required data and formulas workout...
  17. B

    Cycle thru Worksheets, Copy Range from Sheet As Image, Create PPT, Paste each image to new ppt slide

    I have a Excel workbook that I am 99% complete on. The steps it performs are: Opens PPT (successful) Creates Presentation in Normal View (Successful) Creates Slide (Successful) Copies Range from Active (1st) Sheet (successful) Pastes range from (1st) sheet to slide 1 (successful) Cycles to...
  18. N

    Copy multiple ranges in one worksheet into different powerpoint slides

    Hi, I have been searching for this but have not been able to find anything. I have a "Summary" worksheet which has been multiple graphs, notes and tables. I wanted to know if anyone has a VBA that will allow me to copy multiple ranges within this sheet into a new powerpoint but on different...
  19. P

    VBA Resize a powerpoint slide that is copied into outlook email body

    Hi all, I have a macro that creates multiple emails and copies a powerpoint slide into the body of each email using the "Getinspector.wordeditor" function. Im now trying to resize (make bigger) the slide that gets pasted into each email body. Any help would be greatly appreciated! Thanks...
  20. P

    VBA Copy a powerpoint slide into email body

    Hi all, Im trying to create a VBA that inserts a powerpoint slide into the body of an email. Not sure if thats even possible... If possible, it would open a prompt to me select the powerpoint file (using Application.GetOpenFilename maybe), then the macro would copy only the first powerpoint...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top