Powerpoint Runtime Error
Contents |
360 games PC games run-time error '-2147188160 (80048240) Windows games Windows phone games Entertainment All Entertainment run time error 2147188160 (80048240) Movies & TV Music Business & Education Business Students & educators presentation (unknown member) : invalid request. automation rights are not granted. Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Slideshowwindow (unknown Member) Invalid Request. Automation Rights Are Not Granted
Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs 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 them; it only takes https://support.microsoft.com/en-us/kb/285472 a minute: Sign up run-time error '-2147188160 (80048240)' vba powerpoint up vote 0 down vote favorite I am using a code to present the presentation properties to a textbox or shape via a command button or Macro. When I run it I get a run time error that say " SlideShowWindows(unknown member): integer out of range. 1 is not in the http://stackoverflow.com/questions/30266343/run-time-error-2147188160-80048240-vba-powerpoint valid range of 1 to 0 What should I do!? Thanks in advance! Sub ReportStuff() Dim oSl As Slide Dim oSh As Shape Set oSl = SlideShowWindows(1).View.Slide ' Test to see if the shape's already there: Set oSh = IsItThere(oSl, "My Text Box") ' If it's not there, add it: If oSh Is Nothing Then Set oSh = oSl.Shapes.AddTextbox(msoTextOrientationHorizontal, 100, 100, 200, 50) oSh.Name = "My Text Box" End If With oSh.TextFrame.TextRange .Text = "Index: " & oSl.SlideIndex & " ID: " & oSl.SlideID & " File: " & ActivePresentation.FullName End With End Sub Function IsItThere(oSl As Slide, sName As String) As Shape Dim oSh As Shape For Each oSh In oSl.Shapes If oSh.Name = sName Then Set IsItThere = oSh Exit Function End If Next End Function vba powerpoint powerpoint-vba powerpoint-2013 share|improve this question asked May 15 '15 at 18:24 dHumphrey 78212 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote SlideShowWindow is only accessible during a slideshow, not in normal/ edit mode. Adding the following line of code above Set oSl = SlideShowWindows(1).View.Slide should hel
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of http://stackoverflow.com/questions/24241846/vba-run-time-error-when-opening-powerpoint-from-excel this site About Us Learn more about Stack Overflow the company Business Learn http://stackoverflow.com/questions/8326134/run-time-error-214718816080048240-datatype-pppasteenhancedmetafile-error more about hiring developers or posting ads with us Stack Overflow Questions Jobs 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 them; it only takes a minute: Sign up VBA time error run-time error when opening PowerPoint from Excel up vote 1 down vote favorite I am currently experiencing a strange error. We have developed a tool that is used by many people and ONE of them has problems after he got a new computer. The macro opens a PPT file located on the network (the user has access to the presentation - I tested invalid request. automation this). Here is the code: Dim ppapp As PowerPoint.Application Dim PPPres As PowerPoint.Presentation Dim MyPath MyPath = Workbooks("MyTool.xls").Sheets("Update").Range("start") Set ppapp = New PowerPoint.Application ppapp.WindowState = ppWindowMinimized ppapp.Visible = True Set PPPres = ppapp.Presentations.Open(MyPath, msoTrue, msoTrue) The macro fails at this line: Set PPPres = ppapp.Presentations.Open(MyPath, msoTrue, msoTrue) Run-time error -2147467259 (80004005): PowerPoint could not open the file The strange thing is that it works for all users except one. The platform is Win7 and Excel 2010. Any help is much appreciated! excel vba excel-vba share|improve this question edited Feb 24 '15 at 0:30 pnuts 33.9k63870 asked Jun 16 '14 at 10:42 user1204121 164211 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote Disclaimer on my answer with a limited knowledge of programming and VBA. My only experience is through excel and word. Is it a problem with the office excel reference library is it? It may be better to make the code late bind rather than early bind if you've got the program go to different systems. Dim the Powerpoint application and presentation as objects and change references to their numerical values. Dim ppapp
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs 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 them; it only takes a minute: Sign up Run-time error '-2147188160(80048240) DataType:=ppPasteEnhancedMetafile Error up vote 0 down vote favorite Seems there is some bug. Can't resolve this problem, all code is running fine and I am able to see the AutoShape is getting copied from Excel file but it is not adding it to PowerPoint. Popping up an error Run-time error '-2147188160(80048240) View.Pastespecial : Invalid Request. The specified data type is unavailable If Range("H" & i).Value = 1 And Range("B" & i).Value = "FRONT" Then objPPT.Presentations(1).Slides(9).Select objPPT.ActiveWindow.View.PasteSpecial DataType:=ppPasteEnhancedMetafile vba excel-vba powerpoint-vba share|improve this question edited Aug 9 at 9:53 Gareth 2,69321144 asked Nov 30 '11 at 12:42 Rajan S 2127 add a comment| 2 Answers 2 active oldest votes up vote 3 down vote accepted Your code will be faster and possibly more reliable if you don't rely on selecting anything: With objPPT.Slides(9).Shapes Set objShape = .PasteSpecial(ppPasteEnhancedMetafile)(1) With objShape ' set coordinates and such here End With End With As to why you're getting the error message, try stopping the code after you've put something on the clipbard. Then switch to PowerPoint, use Paste Special to see what paste options are available. If EMF isn't one of them, that's your problem ... you're not putting anything in EMF format on the clipboard. share|improve this answer answered Nov 30 '11 at 20:48 Steve Rindsberg 2,637175 add a comment| up vote 0 down vote I had a similar issue, but I found a different solution; it may be specific to what I