[原创]vb 中调用powerpoint 对象错误1

最新推荐文章于 2023-04-21 10:53:47 发布

原创最新推荐文章于 2023-04-21 10:53:47 发布 · 2.9k 阅读

0 ·

CC 4.0 BY-SA版权

本文为博主原创文章，转载请显著位置标明出处，未经博主允许不得用于商业目的。

文章标签：

#powerpoint #vb #microsoft #application #command #basic

vb 专栏收录该内容

14 篇文章

订阅专栏

本文介绍了一种在使用VBA代码自动打开PowerPoint文件时出现的"thepowerpointframewindowdoesnotexist"错误，并提供了解决方案。关键是确保在尝试打开演示文稿前至少显示一次PowerPoint应用窗口。

[个人原创，如转载请说明出处]

错误："the powerpoint frame window does not exist"

Private myp As PowerPoint.Application
Private Sub Command1_Click()
Dim mypp As PowerPoint.Presentation
Set myp = New PowerPoint.Application

Dim pptname As String
pptname = App.Path & "/test.ppt"

Set mypp = myp.Presentations.Open(pptname) -->错误发生位置

在microsoft support 中是这么说的：

This error will occur if you use the Application.Presentations.Open method before showing the PowerPoint application window at least once.
Microsoft provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. This Visual Basic procedure is provided 'as is' and Microsoft does not guarantee that it can be used in all situations. Microsoft does not support modifications of this procedure to suit customer requirements for a particular purpose.

If you want PowerPoint to be essentially invisible, you can use the following command to minimizePowerPoint's application window before opening the presentation file:

ppt.AppWindow.Windowstate = ppWindowMinimized

This line must come after the "ppt.AppWindow.Visible" command, otherwise the window will not be minimized. The code might look something like the following:

   Private Sub Form_Load()
      Dim ppt As Object
      Dim pres As Object
      Set ppt = CreateObject("PowerPoint.application.7")
      ppt.AppWindow.Visible = True
      ppt.AppWindow.Windowstate = ppWindowMinimized
      Set pres = ppt.presentations.open("c:/windows/desktop/test.ppt")
   End Sub
也就是说，必须在使用presentations.open之前最少应显示1次application。
powerpoint2003下与上述代码略有不同（在错误发生位置之前加入）：

myp.Visible = msoTrue
myp.WindowState = ppWindowMinimized