生成一个PowerPoint presentation使用VBA和Excel [英] Generating a powerpoint presentation with VBA and Excel

问题描述

我对PowerPoint演示模板presentation。
我想与在链接Excel工作表中的值I输入，以取代通用的自动占位符。

I have a template presentation on powerpoint. I would like to replace automatically generic placeholders with the value I input in an linked excel worksheet.

我开始在本周开始时看着VBA，我不是真的还没有熟悉的语法，但我很乐观，我会找到一个方法来理解它。

I started looking at VBA at the begining of the week, I am not really yet familiar with the syntax, but I am optimistic I will find a way to understand it.

我已经把[]无论我想要一个值输入：

I have put "[ ]" everywhere I want a value input:

Excel工作表present本身是这样的：

the excel sheet present itself like this:

我想有一些指引（第一，知道它确实是在PowerPoint可能）帮我在正确的方向开始。

I would like to have some pointers (first, to know if it is indeed possible in powerpoint) to get me started in the right direction.

是否需要一个PublicSub（）？
我在使用PowerPoint或Excel写宏？

Does it need to be a PublicSub()? Am I writing the macro on Powerpoint or in Excel?

我可以使用类似LookupV一个fonction得到的值替换占位符？

Can I use a fonction similar to LookupV to get the values to replace the placeholders?

我猜想是这样的：

（方的问题：我可以使用正则表达式VBA内）

(side question : can I use regex inside of VBA?)

for each "\[.\]" '(or characterString.startsWith("[")
lookup characterString in excel, return column 3
end each

这将是可能的吗？

Would this be possible?

感谢你在前进，我真的AP preciate的帮助。

Thank you in advance, I really appreciate the help.

推荐答案

找到一个近似解，但更简单比code写作。

Found an approximate solution, but simpler than code writing.

• 开启Excel中，


• 填充值，并将其复制到PowerPoint演示presentation：使用特殊粘贴单元格之间（细胞或/单元格区域）你想要的选项。


• 一起选择粘贴链接选项和对象的工作表Excel中，选择确定。

这两个文件将被链接。您可以在Excel中更改数值，而他们也将改变在PowerPoint中。该格式化是在Excel中完成。

Both files will be linked. You can change the values in Excel, and they will change also in powerpoint. The formating is done on excel.

为了改变他们的Excel后更新以PowerPoint中的所有值时，PowerPoint需要重新运行，并在应用程序的重新启动，接受更新框提示。

In order to update all the values in the powerpoint after changing them on excel, powerpoint needs to be re-run, and at the restart of the application, accept the updating box prompt.

我觉得这更简单的比其他解决方案。

I find this simpler than the other solutions.

这篇关于生成一个PowerPoint presentation使用VBA和Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！