powerpoint

hi, how to create a powerpoint document wit vba any link, any advice. thanks

Good Morning Sir, My name is Ben I have two file one is excel sheet ( mastersheet) and other is power point. I made a chart in excel sheet according to table . I copied this excel chart and paste in the powerpoint. My question is : when I am changing the value in excel sheet table , I want...

I am a school teacher, and each class I open up with a focus question displayed on the SmartBoard where students are supposed to answer the question in their notebook. They have 5 minutes after the Tardy Bell to complete their answers. I'd like to create a presentation that counts down in text...

Okay. i have been using the attached code for some time without issues in my files. However, within the past few days, I have been getting a run time error that is very random in its appearance. The code below is simplified to create two slides in PowerPoint, where one Excel table becomes one...

I have a vba code that copies some data from Excel, and then pastes the data into powerpoint to create a bar chart. It does this this by pasting the data into the bar chart excel sheet. The issue I'm running into is that I the data that gets pasted to the powerpoint chart will differ in size...

I have a code that loops through a worksheet and copies data to a powerpoint table. I'm trying to also make it where it will highlight the cell with a color if it is a certain value. I can't seem to get it to work. Any help would be appreciated. j = 1 With ppslide.Shapes("table1") For k = 3...

Im trying to create a VBA code that will take several ranges from excel, and turn them into linked pictures in a powerpoint presentation, however i cannot get the pictures to become linked. So far, i have managed to combine pieces of code which now makes unlinked pictures and sends those to...

Im looking for a way to take ranges in excel turn them into linked pictures in a power point presentation. I currently got most of it down, by combining a few diffrent codes i found, except i cannot get the pictures to link to the ranges, which sadly is a must. My current code: Sub...

Hi I use excel to do calculations use paste link to link to powerpoint presentations which are view on a large TV monitor. I have a number of slides which rotate. At the minute when I make a change in Excel I have to come out of the powerpoint, make the change in Excel then restart the...

I have this below code and it is WORKING FINE. I have a dropdown list in column A1 and its data validation range is H1:H4. i have applied loop so its changing the drop down value automatically then below code is copying excel range A1:E9 and pasting as image in PowerPoint slide. what I...

Hi Guys, how is everything? I have excel sheet contains 3 pictures, Picture1, Picture2 and Picture3. How to write VBA code to open specific existing PowerPoint file, delete any pictures in this PowerPoint file first, and then to copy Picture1 and paste in slide 2, Picture2 in slide 5 and...

I am involved in converting ASP e-elearning courses to Storyline. These ASP courses are defined by Excel documents. The Excel documents are broken down to three worksheets: Training, Question and Exam. (I'm focusing today on the Training worksheet.) Storyline allows for the importation of...

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

I send charts Excel to PowerPoint using VBA (pasted as a picture). In Excel < 2013 to either PowerPoint < 2013 or 2016 the shape arrives in PowerPoint with the same size as it was in Excel. However with Excel 2016 to Power 2016 the shape ends up being approx 125% of the original shape (yet...

Hi I have a macro that creates an email and copies a powerpoint slide into the body of the email using the (.GetInspector.WordEditor) function. However the quality of the slide is very blurry (even if I dont adjust the size of the slide). If I just do a manual screen clip of the slide its...

Hello All, I have powerpoint presentation and each slide has multiple shapes on it. Requirement is to update these shapes with values from excel sheet dynamically. Not all shapes are to be updated (ex. title, placeholders in footer etc). However, chart data, tables, few textboxes etc are to be...

Hi all, I have a macro that creates multiple emails and copies a powerpoint slide into the body of each email using the "Getinspector.wordeditor" function. Im now trying to resize (make bigger) the slide that gets pasted into each email body. Any help would be greatly appreciated! Thanks...

Hello, I am stumped on an issue an amateur of hack at VBA. I have tried to find a solution on-line but have failed in every attempt. So I defer to the knowledge of this group to possibly help me. I am trying to create a message box to prompts users to save an extracted PowerPoint file, using a...

Hi all, Im trying to create a VBA that inserts a powerpoint slide into the body of an email. Not sure if thats even possible... If possible, it would open a prompt to me select the powerpoint file (using Application.GetOpenFilename maybe), then the macro would copy only the first powerpoint...