1. D

    PowerPoint Macro: List Fonts at ComboBox - Optimization required (Execution too Slow - More than a minute and half)

    Experts, i created a form to load in ComboBox ALL Installed Fonts on system & sort them. Macro was created in PowerPoint; it takes More than a minute and a Half to finish the execution and show the form. It could be accelerated to reduce it (30 secs for example)? I guess the way that i...
  2. R

    Excel/powerpoint Micro? Link? other ideas?

    I wanted to see if anyone has any ideas without going into a lot of details- basically i have 1 excel sheet that is updated with a bunch of information- this information updates every month to add in new items- with this excel spread sheet there are pivot tables (about 11 and i may add some...
  3. G

    Paste from Excel to specific row and column in Powerpoint table

    The idea is to select a specific row and column in a table within PowerPoint and paste values from excel or from the clipboard. I cannot get the macro to paste what I have already copied from the clipboard into the selected cells in the table. I cannot get the macro to link to excel when I'm in...
  4. W

    Runtime error 1004 when trying to create a PowerPoint presentation

    I am using the following code to create a PowerPoint presentation. Sub PowerPoint() Dim ar As Range, R As Range Dim PowerPointApp As Object, myPresentation As Object Dim mySlide As Object, myShape As Object 'Dim PowerPointApp As PowerPoint.Application, myPresentation As Presentation...
  5. Dr. Demento

    Pasting linked range or chart from Excel to PowerPoint

    I'm having trouble finding an example of the method of pasting a range or chart from Excel into PowerPoint as a linked object. A link would be great. Thanks y'all.
  6. H

    Excel VBA - Excel to PowerPoint - turn off PowerPoint Screen Updating

    I would like to be able to send data from Excel to PowerPoint with VBA. For example, I might like to populate a table in PowerPoint using data from Excel. I have code that does this, but it can be very slow. The trouble is PowerPoint seems to refresh with every change. In Excel it is possible to...
  7. Sanjeev1976

    Excel to Powerpoint - Link and editing range

    I have made different scenarios in Excel, which are then linked to a Powerpoint presentation. I'm trying to get the listing of these ranges of various links in the excel file. And the possibility of modifying the range in the links, which will then get reflected in the Powerpoint presentation...
  8. P

    Excel VBA to Change PowerPoint Slide Size

    Hi All, I have some code that takes a range from excel, creates a PowerPoint presentation and paste's the range from excel as a picture in PowerPoint - which works. The issue I have now is that PowerPoint opens in Widescreen format and I wanted some code for excel to change the slide size to...
  9. S

    Link Excel to Powerpoint

    Hi All, I have a Powerpoint presentation that pulls data from a worksheet from excel into it. I have tried the embedded option with update link ticked. I have managed to get the embedded object to auto update with no problems. The issue arises when I have another workbook open that is used...
  10. B

    VBA Code Question

    Hey all! I was wondering if anyone had a VBA code string to embed an outlook calendar into powerpoint. Thanks!
  11. S

    [VBA] Positioning Chart in Powerpoint after copy pasting from Excel

    Hi, I'm not sure how to refer to a picture of a chart that was copied from excel and pasted into powerpoint. The macro copies 4 charts in total and pastes them into one slide. I looked at the selection panel and they are named Picture 1, Picture 2, Picture 3 and Picture 4. I tried referring to...
  12. Z

    How do i identify an open powerpoint presentation in excel?

    I'm trying to write a macro that automatically uploads a chart to powerpoint but it currently makes a new presentation everytime I try to do it. I got the macro from the internet and tried to modify it but nothing I try seems to be working Here's the code(not my code) below Sub ChartX2P()...
  13. A

    Using Macros to Make Powerpoint Slides from Excel

    Hello, I am trying very hard to find a solution to this but so far nothing works... how can I write a code for a macro that takes a chart or table or cell from Excel and uses it to create the respective Powerpoint slides? Anyone have experience with this? Furthermore, I am using Mac currently...
  14. P

    User form in PowerPoint to feed Excel database

    I'd created a presentation/tutorial in MS PowerPoint, run it in a terminal mode, where users navigate through vba coded buttons. Now, I'm figuring a way to capture who views the PowerPoint (also, trying to capture their feedback). Could anyone please help with a vba code that could be tied to a...
  15. M

    Updating links from excel 2016 to powerpoint 2016 by clicking on an action button

    Is is possible to build an "action button" in PowerPoint 2016, that will allow the links on that slide to update by clicking on, instead of right-clicking and selecting "Update Link" on the pop-up menu? Is there a macro that can be assigned to the "blank" button in PowerPoint? If possible, this...
  16. F

    Make PowerPoint macro SaveAs overwrite without warning popup

    Hi, is it possible to write a code to Excel VBA that saves a PowerPoint presentation to SharePoint with a dynamic name (changes according to a specific cell value) and overwrites the existing file, if there is one? This is my code now, and it doesn't work. Application.DisplayAlerts = False...
  17. P

    Issue running PowerPoint through Excel

    Hi, I am having an issue whereby I wish to update a PPT template through Excel VBA on my Mac. I am able to open the template and save a copy of it no problem, however I am having a problem where I am unable to select objects on PPT slides to update without Excel crashing. Please see the below...
  18. 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...
  19. Z

    Call a specific picture (PNG) to PPTX according to condition

    Hi, I have a list in excel sheet that has themes (words analysis) this list is generated from pictures that have these words. What I need is to create a macro to call any picture to pptx if it meets the condition below: If I choose the theme "Growth", then I need all the pictures that under is...
  20. K

    Excel workbook to powerpoint with animation

    I'm not so good in VBA so I hope someone with more knowledge can help me. I have a *.xls file with nine Worksheet, in each worksheet there are two charts. What I want to do is to move the two charts from worksheet one to first page of a powerpoint file, place the two charts next to each other...

Some videos you may like

This Week's Hot Topics