powerpoint excel vba

Hello Comrades, I am new to Excel VBA so please excuse any misuse of excel terminologies. I used some code I found on a Youtube tutorial video to export from excel to PowerPoint using VBA. The code worked to an extent until I tried to modify it - now I'm stuck. I want to export a range of...

Hello Excel Gurus, I'm trying to link my excel tabs sheets to a powerpoint template. However, whenever I run the macro, the charts overlaps in the slides. Is there any way where I can set the slide view to 100%? Whenever I open the PPT, its always set to 115% - not pretty sure if this is the...

Hello Gurus, Good day! Could you possibly help me amend the codes I found below: Basically, I am trying to create a PPT Template for my report - the charts, table format and tab names in excel are same. Is there any way to copy the format in excel (as seen in the excel print preview) on the...

I created a spreadsheet with a drop-down that changed the data on display in the graph for the selection. I've been asked to create a powerpoint pack that shows each of these graphs on a different slide. There are 35 options in the drop-down. There are actually two graphs for each option...

Good Morning/Afternoon/Evening Everyone, As you may already have imagined, VBA has kicked my butt to the point where I needed to bother you guys, so apologies for that. Summary of effort- I have a pre-made Powerpoint template (graduation certificates for students) that has two fields that...

Hi guys, I am new and please forgive me, if am not specific enough. I would like to export all of the charts using vba code in a horizontal order from a specific worksheet (sheet1) to a specific powerpoint which is already saved at the end of a given path. The powerpoint file as well as the...

Hi, I want to open a PowerPoint file from a location which is shared by more than one employee, so I can work on the excel macro and when they open it the macro can open the same presentation that I have done the macro for. cause I want to work on the excel then I want to copy all charts to...

Hi, I'm not too sure if this can be done or how difficult it would be but here it goes. If you have an Excel file and a PowerPoint presentation, that are on the same network but are being displayed on different computers, could the Excel document control what shows on the PowerPoint? For...

I have an odd problem and was wondering if anyone has a better approach altogether vs. helping me fix my current approach. I have a robust excel and through a working macro: 1. I created 150 small charts and update their data 2. Creates multiple slides. This all works fine, but everytime I...

Hi all, I have been working on the following code to copy paste the following: - grab the header (Row 1) - grab each group of data in pairs of 5 (Row 2-6, 7-11, 12-16, etc.) - paste into Powerpoint slide I have written the following so far: 'grab header row Set head =...

Hi, I have automated a process of pasting Excel ranges as images into PPT through VBA. The dimensions like ".width",".height",".left" and ".top" are set after pasting the image. I was initially working on Windows 7 and had the dimensions according to them. But when I tried to use the same...

I need to be able to copy a certain range from a sheet in excel to a certain slide in PowerPoint. I have some code taken from the internet and after lots of fiddling around I can't get it to what I need. The code I've got opens up a new PPT doc, but I need the copied data to be pasted into a...

I am making a macro that will export data from an excel sheet to a powerpoint presentation to skip repetitive copy and pasting. Some of the data I'm grabbing is of variable size. I want to use the input box to allow the user to select the needed ranges. However, upon opening the powerpoint...

Hello! I am working on creating a macro that takes excel documents and pastes them into a Powerpoint 2016 document. I am almost there but I can't get the content to paste into a specific PowerPoint template...if I open powerpoint first then it will adopt the theme/template that is currently...

Greetings, I've written a macro that creates PowerPoint charts from data in an Excel workbook. It is nearly functional, except for a Method ‘Range’ of object ‘_Worksheet’ failed error message. The macro is run in a PowerPoint instance with no slides. It creates the correct PowerPoint...

I've created a macro in PowerPoint that opens up an Excel workbook, loops through the sheets in the workbook, creates PowerPoint charts and populates them with the data from the Excel sheets. Just to make it clear, the macro is run from PowerPoint. I now have the need to make the data...

Good Afternoon, I was wondering if anyone could help me. I have searched the forum and I can find posts regarding positioning text boxes on Powerpoint using VBA, however none relating to what I was after. I am working on price maps and I have used a VBA so that I can update the price boxes...

I have a PowerPoint presentation that has been created through VBA in Excel, to this presentation I have applied a custom template including various custom layouts. I have no issues referring to the specific slide in PowerPoint through Excel VBA, but when trying to change the layout to one of...

Hello, I Need to duplicate a slide and then write onto that slide. My code duplicates the slide but just after gives a type mismatch error. Any help ? where dim pptSlide as PowerPoint.Slide, dim oPPTApp as Powepoint.Application

Dear all, I am currently facing another challenge. I want to have a script that has the following logic: - If there is one shape, keep it centered. - If there are two shapes, move the first to the left and the second to the right by enough that they don't overlap. Resize them as well if they...