ppt

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...

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")...

Hi guys, Have been looking for answers in other threads but could not find the exact case. Im using userform button to call VBA code to Open PPT presentation with FileDialogOpen but im struggling so need help. Code for now is: Dim fd as FileDialog Dim fullpath as string Dim fileselected as...

Hi guys, Have been looking for answers in other threads but could not find the exact case. Im using userform button to call VBA code to Open PPT presentation with FileDialogOpen but im struggling so need help. Code for now is: Dim fd as FileDialog Dim fullpath as string Dim fileselected as...

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...

Hi, I am trying to automate the following steps: Open a PDF file open a PPT file In the PDF, goto a specific page (e.g. page 5) and copy/screenshot the contents. In the PPT, goto a specific slide (e.g. slide 3) and paste the image. Adjust the image so that it is located in position 5 from top...

Hi, The question regarding Find and replace in PPT VBA. I am trying to find the file path of the linked objects in a PPT and replace part of it with the latest files. Can you please help me how to do it? Find = March month file name Replace = April month file name This ppt has more than 200...

I have data on a sheet that has columns named Product code, product name, image1, image 2 and I need a code for ppt so that I can choose any product and it's related columns directly from ppt slide

I have the following code in Excel: Private Sub MonthlyToplinePPT() ' Opens Presentation.pptx Dim PPT As Object Set PPT = CreateObject("PowerPoint.Application") PPT.Visible = True PPT.Presentations.Open Filename:="C:\Topline\Topline Writeup.pptx" With PPT.ActivePresentation.SlideShowSettings...

Taking this code I would like to add the ability to have the PPT automatically open in slideshow mode: Private Sub MonthlyToplinePPT() ' Opens Presentation.pptx Dim PPT As Object Set PPT = CreateObject("PowerPoint.Application") PPT.Visible = True PPT.Presentations.Open...

I am getting the error code "Method of 'Open' of object 'Presentations' Failed on the last line of code before the End Sub: Private Sub MonthlyToplinePPT() ' Opens Presentation.pptx Dim PPT As PowerPoint.Application Set PPT = New PowerPoint.Application PPT.Visible = True...

I have a set of financials that link to a PPT for our monthly presentations. Each fiscal year we create a new excel WB. Everything is exactly the same, the only difference is the name of the file. So instead of the excel file saying FY18, it now says FY19 Is there a way to point the PPT to...

Hi everyone, I am new to linking excel with other apps, and was wondering if there is a way for me to copy and paste my spreadsheet into ppt slides? only thing is, I have a spreadsheet with hundreds of rows. I'm looking for a way to loop through and paste every 15 rows into a new slide, along...

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...

Hello, I'm looking for a vba code that would save an excel file based on an open PPT file. Is this possible? Thank you

Hello everybody, I read a lot about the Runtime Error "462". And concluded that the my problem is that somewhere in my code I haven't used the appropriate Object variable(s). I'm very new to VBA and have been searching for 2 whole days now. Hopefully someone can help me. My code: Sub...

I have a PowerPoint where the background is blue (I cannot change). In order to make the information stand out, I have the excel information in white - however, I can't see if unless I color the excel background. How do I keep the excel font white so that it shows in the PPT? is there a way...

Hello, I was trying to look up for this formula, but can´t specify correctly the way of slide in PPT presentation, where i need to copy in some informations from the sheets. Sub CopyToPPoint() Dim newPowerPoint As PowerPoint.Application Dim activeSlide As PowerPoint.Slide...

Hi, Not sure if what i'm asking is possible, but thought i would ask... i'm looking for a way to export data from a certain cell group (for example A1 to D4) to a existing PPT presention. So, in theory, when i click a button on the excel table, it will copy everything from the needed cells to an...

Hi Guys. I know there is a lot of threads on how to copy paste picture from xls to ppt via VBA. However my problem is a bit different. I would like not to define the shape location by height, weight and top, left options. I'm thinking of having the object (Content Placeholder) already...