ppt

  1. 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")...
  2. S

    Using FileDialog to Open a PPT through Excel VBA code

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

    Using FileDialog to Open a PPT through Excel VBA code

    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...
  4. 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...
  5. M

    vba to copy a PDF page

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

    Find and replace using PPT VBA

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

    Link ppt to excel

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

    VBA Code that opens a PPT file...now need PPT code to return back to the opened Excel file.

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

    Excel VBA Open PowerPoint into slideshow mode

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

    Excel VBA Open Powerpoint File

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

    Excel to PowerPoint - New Excel WB

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

    vba for exporting to powerpoint

    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...
  13. 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...
  14. M

    Save Excel File based on Opened PPT File

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

    VBA Runtime Error 462 - where does the missing object variable go?

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

    Excel to PPT - Font/Color issue

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

    Problem with Range of slide in PPT, where i need to copy in.

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

    Macro (or any other way) to export data from Certain Cells to a PPT presention

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

    VBA paste Excel range as picture in ppt EXISTING SHAPE

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

    2-Excel WB's to 1-PowerPoint?

    Is it possible to have two (or more) excel workbooks linked to one powerpoint?> I currently have a financial template setup to compile data/information that is then linked do a powerpoint. This way, at each month end, you select the latest date and the most recent information is populated into...

Some videos you may like

This Week's Hot Topics

Top