1. S

    VBA to paste to an existing table in PowerPoint

    I am trying to copy a range from Excel and paste it to an existing table in PowerPoint. I am able to paste one range but when the try to populate multiple tables, it will only populate the last one requested. Sub Transfer() Dim PPT As PowerPoint.Application Dim PPTPres As PowerPoint.Presentation...
  2. Jyggalag

    Embed fonts in the file - PowerPoint (automatic function available?9

    Hello everybody, Whenever I open a PowerPoint document, the function "Embed fonts in the file" is turned off: Is there any way in which I can make it so this is automatically turned on? Thank you! :) Best regards, Jyggalag
  3. Jyggalag

    Neutralize/reset "info", "properties", "related dates & people" in Excel/PowerPoint

    Hello everybody, I am currently looking at excel/PowerPoint, where you have the following when you open a document: In the cases above, I have simply opened a blank document. However, what annoys me is that if I use a template from any prior documents, it will say the names of the authors...
  4. A

    Saving all open PPT within Excel

    Hi all - thank you so much with my previous question (literally saved me hours each month!) Question I have an Excel Workbook that exports standardised reports each month directly in to a fresh PowerPoint file. This works great, but the problem I have is that I suddenly have 20 open PowerPoint...
  5. O

    Code to delete unused cropped region

    Hi there, My goal is to delete the cropped space of images that is currently unused. That is, after an image has been cropped, I want to use "compress picture" function in excel/word/powerpoint to batch process this over multiple files. My problem is that I can do this just fine in excel...
  6. J

    Copy contents of an Excel cell into a powerpoint shape

    Hi all, first time posting, thanks a lot in advance! I'm building a powerpoint to demonstrate a concept for a quiz show. As part of this I need to have shapes within powerpoint that can animate in, appear/dissapear etc, to demonstrate the money values that are in the game. These money amounts...
  7. C

    Copy and Replace Excel Table to PowerPoint Table data

    Hi Everyone, I have an Excel Sheet which contains a range of values as Table, I want to copy those values and replace them in the PowerPoint table(which is the same range as source table). My slide may contain one or more tables so I will identify them using table name, Below is the code which...
  8. Dermot

    Merging Excel to Word and Powerpoint

    It is not difficult to merge Excel data to Word documents, but this destroys the bookmarks, and if you find you want to redo the merge after you've substantially modified the Word document, that can be frustrating. I wanted a merge that could be repeated as often as required, which meant...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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.
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. B

    VBA Code Question

    Hey all! I was wondering if anyone had a VBA code string to embed an outlook calendar into powerpoint. Thanks!
  19. 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...
  20. 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()...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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