powerpoint

Hello MrExcel experts. Please help to make VBA script that can merge ppt files. I have 11 slides, 1 is master slide and 10 are individual report slides. I want a VBA code to merge all individual report slides into my master slide. All slides are in the same folder. Thanks a lot for anything you...

I've looked around and haven't managed to find and/or put together what I'm looking for. I've made a "template" using text(number/letter/words/symbolss) on PowerPoint as follows: The same text (numbers in this case) has been inserted into column A in Excel - the Find column. The text (words)...

Hello, the code below works beautifully but how can I adjust it when I have more columns of data? I assume I need to adjust the offset line? Say I had a phone number or address? thanks in advance! Option Explicit Dim pp As PowerPoint.Application, ppPres As PowerPoint.Presentation...

Using trigonometry, it is possible to calculate the path an object will follow when hitting the inside walls of a closed rectangular area. Here are the relevant points of the code: The input variables are the starting position and angle, between 1 and 89 degrees. The values are hardcoded but...

I am trying to make a change to a VBA script. The VBA script is from Contexture (Create PowerPoint Slides From Excel List with Free Macros). Essentially the VBA takes data from Excel and automatically creates PowerPoint slides. It works as designed with two columns. However, I need more data in...

Hi all, I'm a Mac user. I'm trying to create a PPT using VBA in Excel to copy a few tables and charts to different slides. However, whenever my script reaches PowerPoint commands, such as the one below, PowerPoint or Excel crash completely and close Set pptPres =...

Hello community, I try to automate XL to PPT. I can transfer single ranges to PPT ( as new slide ) with following method. Dim PP As PowerPoint.Application Dim PPpres As PowerPoint.Presentation Dim PPslide As Object Dim PpShape As PowerPoint.Shape Dim SlideTitle As String Dim SlideNum...

Hello: I'm a newbie re: this type of VBA but have done a lot of research (and testing) on the matter before posting here on this site. The code I've come across is too complex for me at the moment. What I would like to do is take slides from an existing presentation and paste those into a new...

Hi there, I have seen posts on how to screenshot a full page from Excel into a PowerPoint presentation. Which works as expected. I am very new to VBA and cannot figure out how to select a range and paste the range into PPT. Any pointers? Thanks ESEM

Hi, as the title explains, how do I gather the displayed range of an Excel OLE Object embedded in a PowerPoint slide via VBA? I've looked through the zipped files but I couldn't find anything in the .xlm files. I've noticed when you 'Edit' the OLE Object, the displayed range is captured by...

Hi all, I am currently facing a weird issue in PowerPoint. When I type text, the border disappears underneath it: It is specifically happening in the cell where it says "test" in bold. Any idea why this is happening? I've looked at my formatting, but cant quite figure out why. Kind...

Hi all, I have a table that looks like this: Whenever I try to remove the borders, I am left with 2 possibilities: Either the border is removed and I am left with a white border (rather than a full green box) where the old border was, or (most common) the cells are merged into one big green...

Hi all, Does anybody know if it's allowed to ask questions regarding PowerPoint here (@Fluff)? If not, can anybody redirect me to a good forum? :)

Hi everyone, I am having some trouble regarding linked charts copied from Excel into PowerPoint. I am working on a powerpoint template, with several charts created in a separate excel file (located in the same folder). I want to be able to update the excel file, and for the powerpoint to...

Hi, I have been stuck trying to find a way to do this, but not able to find anything. So, I have an excel file with columns and multiple rows. So each column is for represents a particular data and each row is for a different client with a different client name. I have a PowerPoint file...

Hello, I am trying to copy some charts from one Excel file to another workbooks and to PowerPoint, for some types of charts I can paste special then paste link as Excel Chart Object in PowerPoint, But for charts like Waterfall the option is greyed out and disabled. I cannot paste as Excel...

Hi, I am using a macro (see below) to update multiple charts in multiple PowerPoint files (macro is stored in .xlm file). The macro is calling multiple functions (SV1, SV2, SV3, SV4, SV5, SV6). Each function is dedicated to update specific PowerPoint file. The question is: Do I need 6...

I need to copy chart1 and chart2 from excel to powerpoint. I have multiple sheets and I am doing this: Sub ppt() Dim r As Range Dim app As PowerPoint.Application Dim currentSlide As PowerPoint.slide Dim Xchart As Excel.ChartObject Dim WS_Count As Integer On Error Resume Next Set app =...

Hi, Does anyone know of an equivalent / similar forum to MrExcel but for PowerPoint? By equivalent / similar I just mean a community group of really knowledgeable, helpful folks as I have found at MrExcel. :-) The PowerPoint forum on Microsoft Community does not quite hit the spot. Many thanks...

I found this bit of code on the forums, and it does a great job of replacing the first instance of a tag, but does not replace the second. For instance if I have <<customername>> in the PPT, I have a cell with John Doe in Excel that overwrites that tag. But if I have a second instance of...