Presentation.saveas An Error Occurred While Powerpoint Was Saving The File
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the an error occurred while powerpoint was saving the file pdf workings and policies of this site About Us Learn more about Stack
An Error Occurred While Powerpoint Was Saving The File 2016
Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs
An Error Occurred While Powerpoint Was Saving The File 2013
Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join
An Error Occurred While Powerpoint Was Saving The File Pdf 2013
them; it only takes a minute: Sign up Excel VBA Can't SaveAs Embedded PowerPoint Presentation in Office 2016 up vote 4 down vote favorite We embed pptx files in Excel, then use Excel VBA code (like below) to open, then SaveAs the pptx file to the user's drive, then programmatically modify the pptx content based on Excel calculations. The an error occurred while powerpoint was saving the file pdf 2010 Excel VBA code below works fine to control PowerPoint 2010 and 2013, but no longer works for PowerPoint 2016. Note: I have similar code for Word and it works fine for Word 2016 (and prior versions). Sub OpenCopyOfEmbeddedPPTFile() 'works with Office 2010 and 2013, but not on Office 2016 Dim oOleObj As OLEObject Dim PPTApp As Object Dim PPTPres As Object Dim sFileName As String Set oOleObj = ActiveSheet.Shapes("PPTObj").OLEFormat.Object 'name of the embedded pptx object Set PPTApp = CreateObject("Powerpoint.Application") PPTApp.Visible = True sFileName = "C:\Users\Me\Documents\testPPT.pptx" OleObj.Verb Verb:=xlVerbOpen 'it opens successfully Set PPTPres = oOleObj.Object PPTPres.SaveAs Filename:=sFileName 'fails here (in Office 2016) PPTPres.Close GetObject(, "PowerPoint.Application").Presentations.Open sFileName 'code to modify the Presentation (copy of the embedded pptx) based on Excel calculations End Sub Error: Run-time error '-2147467259 (80004005)': Presentation.SaveAs : An error occurred while PowerPoint was saving the file. Also, the following PowerPoint VBA (not Excel VBA) works fine for normal documents (not embedded in Excel), but fails when I run it in an opened embedded pptm. Works fine in 2013 and 2010 embedded pptm's. ActivePresentation.SaveAs FileName:="C:\Users\Me\Documents\testPPT.pptm" Err
Forums Excel Questions having problems getting excel vba to save a powerpoint Results 1 to 8 of 8 1Likes Top All This Page 1 Post By an error occurred while powerpoint was saving the file pdf 2016 sumhungl0 having problems getting excel vba to save a powerpointThis is a converting powerpoint to pdf problems discussion on having problems getting excel vba to save a powerpoint within the Excel Questions forums, part of the convert ppt to pdf online Question Forums category; working with excel to make a powerpoint of a few ranges that i need to send out each week. i ... LinkBack LinkBack URL About LinkBacks http://stackoverflow.com/questions/38487556/excel-vba-cant-saveas-embedded-powerpoint-presentation-in-office-2016 Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Dec 2nd, 2014,03:01 PM #1 sumhungl0 Board Regular Join Date Jan 2014 Posts 100 having problems getting excel vba to save a powerpoint working with excel to make a powerpoint of a few http://www.mrexcel.com/forum/excel-questions/821804-having-problems-getting-excel-visual-basic-applications-save-powerpoint.html ranges that i need to send out each week. i usually do this manually and would like to get this process automated. i have it to the point now that it will create the powerpoint and paste the ranges i need. the powerpoint is just the way i need it. the problem is when i try to save the powerpoint, i get an error. i cant get anything to work to get this saved. anybody have any ideas? Code: Sub wpp() Dim rng As Excel.Range Dim PowerPointApp As PowerPoint.Application Dim myPresentation As PowerPoint.Presentation Dim mySlide As PowerPoint.Slide Dim myShapeRange As PowerPoint.Shape Dim fileNameString As String Dim D As Integer Dim N As Date Dim iCol As Long, iRow As Long, iRow2 As Long Dim userResponce As Range Dim wTitle As String ThisWorkbook.Sheets("weekly").Select 'Copy Range from Excel Set rng = ThisWorkbook.ActiveSheet.Range("a3:c13") 'Create an Instance of PowerPoint On Error Resume Next 'Is PowerPoint already opened? Set PowerPointApp = GetObject(class:="PowerPoint.Application") 'Clear the error between errors Err.Clear 'If PowerPoint is not already open then open PowerPoint If PowerPointApp Is Nothing Then Set PowerPointApp = CreateObject(class:="PowerPoint.Application") 'Handle if t
be down. Please try the request again. Your cache administrator is webmaster. Generated Mon, 24 Oct 2016 08:34:37 GMT by s_nt6 (squid/3.5.20)
Add new topic Add-in Express for .NET and VSTO Topics 1 - 25 of 10669 First|Prev.|1 234567891011|Next|Last Subject Replies Views Last Post Info Error in OutlookFormsManager when Windows scaling set to 150% Exception thrown and red cross/box drawn when minimizing a form region Author: ben.nicholls 0 1 24 Oct, 2016 00:57:28 Author: ben.nicholls Slow Speed When Working with Excel Objects Author: mwynn 0 13 23 Oct, 2016 11:09:20 Author: mwynn adxloader loader error after update Addin fails to load because of adxloader error after update. Author: ideaFocus 0 11 23 Oct, 2016 01:52:28 Author: ideaFocus com wrapper Author: mathieu ladroue 1 16 22 Oct, 2016 08:44:22 Author: Andrei Smolin Visual Studio 2013 issue with addin express Author: Kyle Johnson 0 16 21 Oct, 2016 14:01:29 Author: Kyle Johnson How to save edits on RTFBody/WordEditor of a mail item and meeting item? Author: Horatiu Muresan 7 110 21 Oct, 2016 05:51:10 Author: Horatiu Muresan Conflicting user.config due to non unique path between 2 addins Author: Pawel Forys 1 39 21 Oct, 2016 05:39:28 Author: Andrei Smolin RTD_Disconnect is called before even refreshing Author: Ranjitha Nagendra 9 77 21 Oct, 2016 05:36:38 Author: Andrei Smolin How to prevent crash when Office Plugin has top task pane and user works with Windows explorer preview panel? (Pages: 1 2 ) Add-in Express for Microsoft Office and .net, Standard Author: David Potashinsky 11 197 20 Oct, 2016 03:18:58 Author: Andrei Smolin How to add icon in List Inbox How to add icon in List Inbox Author: diego cecatto 5 100 19 Oct, 2016 06:50:18 Author: Andrei Smolin Activation context generation failed Event Log error - Activation context generation failed for adxloader.dll.Manifest Author: Mukesh Kumar 3 55 19 Oct, 2016 01:43:01 Author: Andrei Smolin Excel version is not defined error in 2013 excel ADXExcelTaskPanesManager.DoAddinInitialize: Excel version is not defined. SetExcelVersionFromRegistry. Author: Jude Milstan 1 40 18 Oct, 2016 09:03:09 Author: Andrei Smolin Add-In located in BottomNavigationPane and collapsing the Outlook Navigation Panel Author: Chris McA 1 57 17 Oct, 2016 08:38:45 Author: Andrei Smolin Add-in startup code freezes when using send-to from Windows Explorer Author: Aaron Robertson-Hodder 5 193 17 Oct, 2016 06:25:51 Author: Andrei Smolin Addin not working for Office 2010 anymore ... after having used the 2016 PIA's Author: Fred Balkenende 6 110 17 Oct, 2016 05:59:36 Author: Andrei Smolin adxOlForm load only one time for a inspector in M