Propmt:Act as a VBA programmer. Write me VBA code to create PowerPoint slides about the sports drink and hydration beverage category. think like a senior CPG brand manager and market researcher. use your knowle
使用合适的图表、图片来增强信息的可视化。 方法二:使用 ChatGPT 和 VBA 代码自动化演示文稿创建 准备VBA 代码生成请求: 编写一个简明的请求指导 ChatGPT,例如:“生成一个 VBA 脚本,用于在 PowerPoint 中创建关于气候变化的三个幻灯片”。 使用ChatGPT 生成 VBA 代码: 向ChatGPT 提出您准备的请求,并接收生成的...
Step 1: Ask ChatgPT for the VBA PowerPoint code You can use a ChatGPT prompt like "Write me VBA PowerPoint codes on [topic]..." However,the more detailed your explanation of the content, the better the result will be.Here’s an example: Write me a VBA code for a PowerPoint presentat...
Part 3 Use ChatGPT and VBA Codes to Automate Presentation Creation Step 1: ChatGPT Interaction Ask ChatGPT for a PowerPoint presentation using a specific topic, content, and design. Copy the generated VBA code. copy code Step 2:Enable Developer Tab Open PowerPoint and enable the "Developer Tab...
17.11 将Excel数据输出到PowerPoint演示书名: 用ChatGPT与VBA一键搞定Excel 作者名: Excel Home编著 本章字数: 414字 更新时间: 2025-03-28 14:59:25首页 书籍详情 目录 听书 自动阅读00:01:22 摸鱼模式 加入书架 字号 背景 手机阅读 举报 上QQ阅读APP看后续精彩内容 下载QQ阅读APP,第一时间看更新 ...
. Try that code in Word or PowerPoint and you’ll hit a “Compile Error” “Method or data member not found”. Unfortunately, ChatGPT’s system can’t make a distinction between code for Excel, Word or PowerPoint – at least not for selecting a file. Asking “Word VBA to choose ...
Then you can copy and paste the VBA code that ChatGPT generated into the Module window, just as the screenshot below. Then you are ready to run this VBA code to generate a PowerPoint file. All you need is to click the “Run” button on the toolbar. ...
在VBE 中,插入一个新模块来编写 VBA 代码。 创建一个名为“CalculateStatistics”的子例程,不带任何参数。 声明用于存储输入值和计算统计数据的必要变量。 使用高级错误处理技术(如“On Error GoTo”、“On Error Resume Next”和“Err.Raise”)实现错误处理。
While I was working on various VBA macros in PowerPoint, I tried using ChatGPT to write and explain existing code. It was useful to create a “rough draft,” but it kept making obvious errors that a human could detect in a second. It functioned as a refined/faster version of Google sea...
Chapter 1 Introduction to ChatGPT Chapter 2 User interface of ChatGPT & Create an Account in Open AI Chapter 3 Solve Mathematical Problems Chapter 4 Solve MS Excel MS Word And MS Access Doubts Chapter 5 Create PowerPoint Slide Within A Minute Chapter 6 Generator VBA Code As Per Your Request...