[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Microsoft PowerPoint

PowerPoint is a slide show presentation program currently developed by Microsoft. PowerPoint presentations consist of a number of individual pages or "slides" that may contain text, graphics, sound, movies, and other objects, which may be arranged freely. The presentation can be printed, displayed live on a computer, or navigated through at the command of the presenter. Slides can also form the basis of webcasts.

Share tech news, updates, or what's on your mind.

Sign up to Post

VBA to Export Excel sheet to PowerPoint:

Hi experts,

I am using the following VBA to export my worksheet to PowerPoint presentation, however if I change the slicer in my Pivot Chart and export again the worksheet, the code is creating a new presentation, rather than a new slide.

I would like to add the new selection into the same presentation, just adding as a new slide.

I believe I need a loop indexing and counting the slides.

Any suggestions, please.


VBA Code:

Sub ExceltoPowerPoint()

Dim PowerPointApp As Object
Dim myPresentation As Object
Dim wb As Workbook
Dim ws As Worksheet
Dim namecheck As Range

Set PowerPointApp = GetPowerPointApp()
Set myPresentation = PowerPointApp.Presentations.Add

Call ExportResourcePlanSlide(myPresentation, ThisWorkbook.ActiveSheet.Range("a2:m40"))

PowerPointApp.Visible = True
PowerPointApp.Activate

Application.CutCopyMode = False

End Sub



Function GetPowerPointApp() As Object

On Error Resume Next
Set PowerPointApp = GetObject(class:="PowerPoint.Application")
Err.Clear
If PowerPointApp Is Nothing Then Set PowerPointApp = CreateObject(class:="PowerPoint.Application")
If Err.Number = 429 Then
MsgBox "PowerPoint could not be found, aborting."
Exit Function
End If
Set GetPowerPointApp = PowerPointApp
On Error GoTo 0

End Function


Sub ExportResourcePlanSlide(ByVal myPresentation As Object, ByRef rng As Range)

'Create new …
0
HTML5 and CSS3 Fundamentals
LVL 12
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

I'm using PowerPoint 2018 for a presentation containing several videos.  I want to Link these videos (not embed) in order to keep the file size to a minimum.  However, when I go to insert video from my PC, the dialog box opens as usual, but I cannot change the drop-down button from Insert to Link.  I know I've done this before - but does anyone know why I can't do it now.  

- I've tried it on two PCs running Windows 10 (latest patches), and Office 365 (again latest patches - I think).
- I've created a new presentation (same results)

Not sure what to do now.....
0
Hi, Currently I have problem about my Kingsoft Presentation ( Free ). everytime I click on hyperlink that linked to video it will pop out this warning ( refer attachment ). Did anyone know how to disable this warning. I already configure at  trust setting but it didn't solve, I try change at registry. also same.. have any solution?. error security warning pop outtrust setting presentationregistry
0
msaccess, powerpoint, vba

I am using vba in msaccess to change link references in powerpoint. The script I found has

Dim oSld As Slide
Dim oSh As Shape

I am getting an error 429, ActiveX Component can't create object.

I think I do not have the proper object library loaded in msaccess 2016.

Any suggestions.

Thanks,
WillieCg
0
I have to do a Presentation and I am only allowed one slide.  I have 5 pictures on it.  

What I was hoping to do is have the slide open and only show the title.  Then when I click the first slide it opens full screen.  The next click closes that slide and opens the second one.  And so forth.

Is this possible?
0
I need vba script that will run in msaccess that opens a power point presentation, update the links and saves the presentation
(office 2016)

presentation name: f:\test.pptx

I am a newbe so I would appreciate it if the script contains all code to execute.

Thanks,

WillieCg
0
I created 1 slide that has the Grow Shrink animation.  When the picture grows a portion of it is behind the picture next to it.   How do I get it to grow and cover the picture next to it?

example
0
I scanned 100 A3 pages into a PPTX file and then shredded them. When I looked at the file, all slides are in landscape format, while I needed them in portrait.

What would be the quickest way to rotate all 100 scanned images on all 100 slides by 90 degrees?
0
Hello, we need to have a way to place PDFs into a shared folder on a server and then have whatever docs are in this folder, be able to show up for all users when they go into their PowerPoint under the Shared tab
0
Some general help please..

I have a power point template for producing certificates and I want to be able to do a mail merge from a excel spreadsheet into the power point template.

I want to mail merge Full Name, Date and Certificate Number from the excel spreadsheet. Then have the ability to produce a PDF document of the certificates for the data entries.

I am guessing you might be able to use a script for this type of work.

Any suggestions?
0
Become a CompTIA Certified Healthcare IT Tech
LVL 12
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Hello,
We have PowerPoint 2013 documents on our Intranet site. There could be times when multiple users have the same doc opened from the site.
Is there a way that we can set these docs up so that users know when someone else has the doc open and that they cannot make any changes to the doc until the other person is finished with it?
0
I have an Excel spreadsheet (about 50 rows), and am planning to create a nice Powerpoint template, with preformatted textboxes, fonts, etc.

I would like to transfer the information from the Excel into the PPT. Each row of the Excel will be one slide in the PPT. Each cell will become one text box. All cells in the same column will end up at the same place on various slides, with same font, etc. The final PPT file will contain as many slides as there were rows in the Excel spreadsheet.

Could someone please show me a way?
0
According to this Greg Maxey article it's possible to customise the context sensitive menu at the bottom of this screenshot both via customUI XML and the older CommandBars model.

Office context menu for text
But is there any way to customise the smaller popup menu at the top e.g. the one with the font formatting controls in it?
0
Why does Power Point (Mac 2018 version) darken images?

When I run the presentation, all my images get darkened. And some become unusable.

Is this a setting i can turn off? I want the images to show exactly as they are in Power Point.

Thanks.
0
I am currently using PowerPoint 365 with Excel 365 and in earlier versions of Excel/Powerpoint if I updated a pivot chart in Excel then that was reflected in my PowerPoint (I was using Paste : Use Destination Theme and Link Data - however I'm finding that even when I refresh the data in PowerPoint, the changes are not always reflected...why is that?

Secondly, where can I find an explanation of the difference between Link Data and Embed workbook - and when would you use one over the other?
0
I'm creating a digital planner and need a little Power Point help. I'm creating the graphics in Paint Shop Pro then importing them into PowerPoint to add the hyperlinks. Then I will be using the Xodo app to finish it and use it on my Android tablet and phone. (IOS users use Goodnotes but I don't have an Apple device).
    So I have tabs around 3 of the sides of my planner. I have the tabs set up on the left side (Jan- Dec) for monthly spreads and I have all those hyperlinks set up ok on all the pages.
   Now I'm working on the top 4 tabs and have all those but one done and that's where I need assistance. I have a "today" tab that obviously leads to the current date in the planner.  
    How can I add a hyperlink that changes daily?  I've seen others with the "today" tab, so I know it's possible, but I don't know how (yet).
    Any idea?
  Thanks!
0
I use this feature often and it's been working but with a recent update, the slides no longer display the synced icon by the slide number and when i open the document it doesnt update.

Any fix?

https://support.office.com/en-us/article/Use-Slide-Libraries-to-share-and-reuse-PowerPoint-slides-C419E77F-8A94-4FC1-A7F0-F5E6CDD7E419#OfficeVersion=2007_-_2013
0
I'm working with a client on an application which will display a list of files which are available for a user to review (file types: pdf, Excel, Word, PPT, Text).

The problem is that after these files are opened:

Application.Followhyperlink pathname\filename

The user has the ability to Save or Save As from the application (Acrobat, Excel, Word, PPT, NotePad, ...) user interface.  Is there any way I can open open the files with some form of command line switch which would prevent any of those applications from allowing the user to even see the File option on the application menu?  I only want them to be able to view and then close these documents.
0
Hi!  We are testing our existing files before upgrading from Office 2010 to Office 365 (Office 2016).

We have a complicated Excel frontend created by users to process data and automatically create charts and graphs and ultimately export everything directly to PowerPoint.

We have done a ton of testing but have only come across one problem that I can't seem to resolve.

VB code that copies and paste a chart from Excel to PowerPoint works in Office 2010 but not in 2016.  
Here's how the code currently exists in Office 2010.
        Set activeSlide = pp.ActivePresentation.Slides(1)
        ActiveSheet.Range("BX146:BY158").Select
        ActiveSheet.Range("BX146:BY158").Copy
        activeSlide.Shapes.PasteSpecial(DataType:=ppPasteOLEObject).Select

Open in new window

This gives us the following error in 2016.
Run-time error '424':
Object required
(also see screenshot in Word doc)

I read posts online and made the following code changes but ended up with the same error.
   
        Set activeSlide = pp.ActivePresentation.Slides(1)
        ActiveSheet.Range("BX146:BY158").Select
        ActiveSheet.Range("BX146:BY158").Copy
       '9/5/18 activeSlide.Shapes.PasteSpecial(DataType:=ppPasteOLEObject).Select 'Runs table
        '9/5/18
        Dim pptshape As PowerPoint.Shape
        Set pptshape = activeSlide.Shapes.PasteSpecial(DataType:=ppPasteOLEObject)
        pptshape.Select
        '9/5/18 end

Open in new window


As I said, this code runs fine in Excel 2010.

Does anyone have any ideas on how to resolve this issue?  Also, please note that we need to be able to paste the object (which is a table in Excel) so that PowerPoint links to the table in Excel and "sees" any updates that may be made in Excel to the table.

Thank you for your help.

Alexis
isummary-powerpoint-creation-error-.docx
0
CompTIA Security+
LVL 12
CompTIA Security+

Learn the essential functions of CompTIA Security+, which establishes the core knowledge required of any cybersecurity role and leads professionals into intermediate-level cybersecurity jobs.

Hi,
in our company we want to install WSUS for multiple branches.
from main office we want to approve the updates.
I need to create  WSUS proposal drawing and PPT if someone can provide me a sample for the same it will be very helpful.

Thanks & Regards,
Mohammed Afroz
0
Hello,

i have a powerpoint presentation with 10 slides. I would like to create an index page where all the index numbers (1-10) are linked to their appropriate slide. So, clicking slide 4 in the index will automatically go to the actual slide 4.
Can one write a macro that will create the index page with links , say slide 1, for any amount of slides in a presentation?

Thank you,
CC
1
On my powerpoint slides
I have the background set.

But the textboxes are all different heights and with different formatting

I would like to click on a textbox
Copy its format
And go to a slide and paste that formatting only

Height, position vertical position fill etc...
0
In the code below, I pass the FillFormat object of a selected shape to the function. I then pass the FillFormat object for the text within the selected shape but it raises a Type Mismatch error. The FillFormat object TypeName is the same in both cases and it only appears as a member of the PowerPoint library and is not duplicated in the Office library. I know I can declare oFF As Object but I'd prefer to understand why am I getting this mismatch error in the first place? To test, you just need to select a shape with some text in it on a slide and then run the Test procedure.

Sub Test()
  ' Format the fill for the selected shape
  Debug.Print TypeName(ActiveWindow.Selection.ShapeRange(1).Fill)
  ChangeFillFormat ActiveWindow.Selection.ShapeRange(1).Fill
  
  ' Format the fill for the text inside the selected shape
  Debug.Print TypeName(ActiveWindow.Selection.ShapeRange(1).TextFrame2.TextRange.Font.Fill)
  ChangeFillFormat ActiveWindow.Selection.ShapeRange(1).TextFrame2.TextRange.Font.Fill
End Sub

Function ChangeFillFormat(oFF As FillFormat)
  ' Do stuff with the fill format
End Function

Open in new window

0
I have a power point file and have some you tube videos embedded in this file. The video used to play OK in the last months, however all of the sudden the video doesn't play anymore.

We have tried disabling hardware acceleration, running the file as admin and so far nothing has helped.

We are in MS Office  2016
0
I have a powerpoint 2016 presentation that I need to send out shortly.  It is critical that I lock it for editing, but it still needs to be able to be printed.
Converting to .pdf is not an option as it must remain in powerpoint.  I cant seem to find a way to do this anymore!  Help.  When I go to File > Info > Protect Presentaion I only see the ability to add a password to open the document...not to restrict for editing.   When I click  'Restrict Access' there is a choice 'Connect to rights management server and get templates'  … which doesn't work, says my machine is not setup, etc, etc.    Mark as Final sounds promising...but seems to still allow anyone to click 'edit anyway' and get past it.

Is there any simple way to restrict editing only?  Need to get this out shortly so a bit desperate for help.  Thanks
0

Microsoft PowerPoint

PowerPoint is a slide show presentation program currently developed by Microsoft. PowerPoint presentations consist of a number of individual pages or "slides" that may contain text, graphics, sound, movies, and other objects, which may be arranged freely. The presentation can be printed, displayed live on a computer, or navigated through at the command of the presenter. Slides can also form the basis of webcasts.