powerpoint

  1. Z

    Copying Linked Excel and PowerPoint files, having new copies link to each other

    I have a PowerPoint template that contains several charts and Microsoft Excel objects linked to an Excel template. I would like to have it so that when the user makes a copy of each file, the new copy of the PowerPoint file is linked to the new copy of the Excel file. Is there any way to...
  2. 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...
  3. S

    Excel Macro to change powerpoint links

    Hi, I have a Powerpoint File, which has many Excel linked linked Charts. Now the folder name and Excel File names are changed. I need a macro to a) list all the links of the powerpoint file. b) I want to update the new link. Help me by a macro to do so. Thanks in advance. Regards...
  4. K

    VBA for Opening and closing powerpoint in Excel

    I have 4 PowerPoint Shows that I need to open, run, close in a specific order. I'd love to be able to code in each PowerPoint to close by clicking an action button and then open the next show. But I'm having trouble finding any good suggestions on the internet. So I thought perhaps opening them...
  5. D

    Setting and adding a Title box in slide script

    I have a script someone gave me to autogenerate a PowerPoint slide from within a workbook. However, I need to add a title box and value into the script and not a VBA guy at all. The script is below...can anyone help me out with the code to create the title box and populate it? I can modify...
  6. R

    excel copy and paste into powerpoint

    I need to copy the data from multiple sheet with multiple range (different range - dynamic) and paste into powerpoint check the current sheet, copy data (example cell no A13 : B19) and go to next sheet copy data ( cell B25 : C35) and go to next sheet... and finally paste in to powerpoint and...
  7. R

    VBA returning errors at random

    I have a VBA code which i use to copy areas from excel sheets, into a powerpoint presentation as a linked image, and then resize and position correctly. While the code works most of the time, the code randomly returns the following error: run-time error '-2147188160 (80048240)'...
  8. A

    Copying to PowerPoint...getting random results

    Hello...I have some code that copies different ranges from different worksheets to different slides in a PowerPoint template presentation. It mostly works like a charm. But for whatever reasons, the results are inconsistent. I would say about 20% of the time, all ranges get copied to all...
  9. A

    Copying stuff to PowerPoint...checking if active presentation is the correct one when several are open

    Hello...it's been a while since I've posted here, but I also haven't been deep into code for a while :) Here's my problem, I have some code that copies ranges from multiple sheets to multiple slides in an existing PowerPoint template. Works like a charm. The code requires the template...
  10. E

    How to reference worksheet object embedded in Powerpoint using Excel VBA

    Hi VBA Gurus, I would like to reference a worksheet object which is embedded in PowerPoint can someone advise how I can reference it using VBA. My code is in Excel Workbook VBA Editor and I have added the powerpoint libary so I will be using th Ealy Binding technique. The original name of the...
  11. R

    link excel cell to powerpoint textbox

    Im looking for a way to link a excel cell to a powerpoint textbox, such that if the cell changes, the text in powerpoint will aswell. Ideally, something similar to the way you can link excel cells to word text. That works by copying the excel cell you want, and using "paste special" and pasting...
  12. 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...
  13. ajjava

    Looking for some assistance in tweaking this code (that another forum user graciously helped me with)

    In a nutshell, the code below takes several picture objects from an Excel workbook (they are charts, but the source system puts them into Excel as pics) and pastes them into a PowerPoint presentation. As it stands, the code works. I just need some modifications to make a bit more dynamic. For...
  14. G

    RunTime Automation Error on copying Excel pictures into PowerPoint

    Hi, I have a macro that generates PowerPoint slides which a bunch of different things from Excel. I have a total of about 50 Slides to generate, often at around 20 slides the code will crash and give a runtime error. When it crashes its always got something to do with this section of the code...
  15. F

    Excel VBA creates PowerPoint Table - how to control bullet points?

    Right now I have code that creates a table in PowerPoint 3 rows x 2 columns. This is created from a worksheet in Excel, by copying a 2x3 range of cells. Within each cell are multiple lines of text. The problem I face is that the text in PowerPoint needs to be bulleted. I used the following...
  16. M

    Excel Waterfall Chart cant embed in PowerPoint???

    Hello all, I'm trying to paste a Excel 2016 built-in 'waterfall' chart into PowerPoint 2016 (Paste Special > Paste Link > Microsoft Excel Chart Object) and the option to 'Paste Link' is grayed out and unavailable. Other charts work (i.e. Bar/Column/Pie) but not 'Waterfall' - does anyone know...
  17. S

    powerpoint table to have color scales similar to excel

    In excel under conditional formatting, there is a color scale option where if I highlight a table and choose a color scale, Excel will automatically highlight my cells with different shades of green, yellow and red, depending on my value. I have a VBA code that currently copies each value in my...
  18. O

    Select certain worksheets via UserForm to be exported to PowerPoint

    Hello! This is my first time posting in this forum, I have already received help multiple times, as my VBA skills are as novice as they can get. I thank you in advance, if anyone is willing to take their time and help me out. I can assume that this isn't a small request, but due to my limited...
  19. M

    VBA code - set print area in excel paste it as EMF in Powerpoint

    Hello, I have the code of a macro from "TheSpreadsheetGuru.com" (good macro for me) I would like to modify the part below. I want to use the print areas in several Excel sheets instead of the areas as per the code below as a source for the copy and past as an Enhance metafile powerpoint...
  20. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top