slide

Hello Team, I have around 30 charts in excel sheet. I would like to copy and paste the same into the powerpoint(6 charts per slide). While pasting the chart into powerpoint slide, the system is linking the chart automatically. Is there any possible way to copy and paste the excel chart into...

I have a macro to resize and position the image in the powerpoint slide. This macro resize the image across the slide the same. Now I have to resize the image differently by each slide. Can you please someone help me how I can do that. <colgroup><col></colgroup><tbody> Sub Pix_Resize() Dim...

Hello Experts, I have the following code which loops through an Excel Workbook and copies all the charts from each worksheet and then pastes into a new power point slide, max of 4 charts per slide. The modification I would like to make is to add a title to each ppt slide and paste the...

We have a file that is generated in Excel, linked in to PowerPoint, and now the lovely folks above all of us worker-bees want to view their specific PowerPoint slides in PDF, but they do not want to have to be bothered looking at anyone else's information. I have the following that saves each...

I have information linked from an Excel doc to a PowerPoint. How do I keep the information from expanding beyond the PowerPoint slide when ever I update the links? Thanks!

Hello, I was wondering if it is possible to use a vba code that will open a UserForm based on the current open slide in Normal/Edit View? I tried the code below, but I'm getting an error message (Object variable or With block variable not set. Sub UserForm() Dim ActiveSlide As Slide If...

Hello, I was wondering if it was possible to create a checklist next to a PowerPoint slide; not a checklist slide. For instance, a slide will have a header, some text and a picture. I was curious to know if I can have a pop-up form or something in the slide with a checklist for us to ensure...

Hello i was wondering if you can help me with my dilemma. i run a small website with a small team of just two people, but i want to make sure they are updating our main attraction on the homepage regularly and be able to track that meticulously. this main attraction is square shaped and...

Hi, I have been for few days trying to figure out the on how to copy data from excel to power point keeping power point format. After searching I found how to move charts but I am not successful in adding the appropriate vba code to add the data from excel table to the power point table Below...

Hi. I am creating a slide based off the data in a pivot table. The Pivot table has 2 filters, "Market" & "HH Characteristic". I need to create a slide for each HH Characteristic within each Market. For example, there are 3 markets and 5 characteristics. For each market, I must create a...

I'm looking to create a query to give me a count of the following subset of data: It must be "HA" , "HB", or "HC" or "HD" in Column A. It must be "Slide 4" or "Slide 5" in column B. It must be "AX123" in Column C. It must be "T" or "T-1" on Column D. When I made the "SUM(COUNTIFS(..." query, I...

Below code works perfectly: Sub ExportToPowerPoint() 'early binding Dim ppApp As PowerPoint.Application Dim ppPres As PowerPoint.Presentation Dim ppSlide As PowerPoint.Slide Dim SlideCount As Long ' Reference instance of PowerPoint On Error Resume Next ' Check whether PowerPoint is running...

Hi, i've been using this code to export a certain range from Excel to PPT (major thx to Haluk for helping me out with it): Sub SendRangeDelete() Dim MyMyRng As Range Dim appPowerPoint As Object Dim filePowerPoint As Object Dim mySlide As Object Dim strPPTfile As String...

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

I've built a tool for folks at work that they can use to enter some data via Excel and have it generate a deck of powerpoint slides. Each slide includes a bunch of bullet statements. I've taken the approach of putting a textbox on the Excel sheet that fits the format of the slide. So they can...

Hi, Every time I toggle between Excel and PowerPoint using vba, ppt crashes and I don't know the reason why. But when I try to run manually by pressing F8, it works perfectly fine as required. I have tried searching a lot of websites but didn't get a work around. My work is simple. I have...

I am creating a report in PowerPoint 2010 with charts on separate slides. The chart is the same layout each time, and the data refers to a different subset of team members. (If it helps, they show forecast project hours versus actual project hours for our developers, split by our...

Hi All, I want to copy from Excel (Filtered Range) and paste in power point slide Each copied Range in separate Slide . Like this I want to loop this action (Count is not fixed). So far I've below code. which is not working as expected. For Each Ccell In Worksheets("RAWDATA").Range("H2:H10")...

Hello, I have a bunch of slides with the same layout - a title box and a linked or embedded range from excel below the title box. I need to loop through all slides and re-set the dimensions for the linked excel range on each slide. I need to write something like: Dim Sld As Slide For Each Sld...

Hi, Can anyone help me to remove blank rows in a powerpoint table? This is created when I have moved data from excel to PPT and it cuts across multiple slides, this is due to the limiting factor per slide being the size of the table (height). As it rolls onto the last slide there are a number...