在使用VBA从Excel打开时，在演示文稿中删除SharePoint幻灯片上的PowerPoint幻灯片并自动保存（未编码且不需要！） [英] PowerPoint slides on SharePoint slides are deleted in the presentation during opening from Excel with VBA and saved automatically (uncoded & unwanted!)

问题描述

你好，

我从Excel运行VBA宏，必须在SharePoint上打开PowerPoint演示文稿，从中读取内容幻灯片并将其写入Excel。

I run a VBA macro from Excel that has to open PowerPoint presentations on SharePoint, read something from a slide and write it to Excel.

Makro在Windows 10 VM上运行了几个星期没有任何问题，但有一天早上所有演示文稿突然不再包含幻灯片了。在我的Windows 7笔记本电脑上，宏仍然正常运行...

The Makro ran on a Windows 10 VM  for some weeks without any issue, but one morning all presentations suddenly contained no slides anymore. On my Windows 7 Laptop the macro still runs fine...

VM运行Office 2013 Standard（15.0.4963.1000）MSO（15.0.5023.1000）32位

The VM runs with Office 2013 Standard (15.0.4963.1000) MSO (15.0.5023.1000) 32-Bit

相关的VBA行：

Dim oPPTApp As PowerPoint.Application

Dim oPPTFile As PowerPoint.Presentation

Dim oPPTApp As PowerPoint.Application
Dim oPPTFile As PowerPoint.Presentation

[...]

设置oPPTApp = CreateObject（" PowerPoint.Application"）

oPPTApp.Visible = msoTrue

Set oPPTApp = CreateObject("PowerPoint.Application")
oPPTApp.Visible = msoTrue

设置oPPTFile = oPPTApp.Presentations.Open（文件名：= PresFile）

Set oPPTFile = oPPTApp.Presentations.Open(Filename:=PresFile)

这里的演示笔不再包含幻灯片了并且已经保存在SharePoint上...

Here the presentation pens and contains no slides anymore and is already saved on the SharePoint...

有人遇到类似的问题，并且知道解决方案/解决方法吗？

Has someone a similar Problem and knows a solution/Workaround?

BR

BjörnWagner

Björn Wagner

推荐答案

这是讨论Microsoft Excel功能的问题和反馈的论坛，我会提出你的问题到MSDN论坛for Excel

This is the forum to discuss questions and feedback for Microsoft Excel features, I'll move your question to the MSDN forum for Excel

https：/ /social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

我们建议适当发布的原因您是否会获得最合格的受访者群体，而定期阅读论坛的其他合作伙伴可以分享他们的知识或从您与我们的互动中学习。感谢您的理解。

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

问候，

Emi

这篇关于在使用VBA从Excel打开时，在演示文稿中删除SharePoint幻灯片上的PowerPoint幻灯片并自动保存（未编码且不需要！）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！