Business & Productivity Difficulty: Intermediate
VBA Macro for PowerPoint and Excel Integration
This prompt guides the user to create a VBA macro that connects a PowerPoint presentation with an Excel spreadsheet. The macro will automatically update the slides with the latest data from the Excel file, ensuring the presentation remains current without manual updates.
Act as a professional VBA developer with expertise in Office automation. Based on the provided [EXCEL DATA], placeholder and [POWERPOINT PRESENTATION], placeholder, create a VBA macro that establishes a connection between the PowerPoint presentation and the Excel data. Ensure the macro dynamically populates slides with the latest information from the Excel file, allowing for seamless updates whenever the Excel file is edited. Deliver the macro code as a structured script ready for immediate implementation.
Highlighted text is a blank. Swap it for your own detail before you send the prompt.
What it produces
- Sub UpdatePowerPointFromExcel()
- ' Code to connect to Excel and update PowerPoint slides
- End Sub
- Sub AutoUpdateSlides()
- ' Macro to refresh PowerPoint slides with Excel data
- End Sub
How to use this prompt
Four steps, about a minute. Nothing to install and no account needed.
Copy the prompt
Use the Copy button above. The whole prompt goes to your clipboard exactly as written. Nothing is trimmed.
Fill in the blanks
Replace [EXCEL DATA] [POWERPOINT PRESENTATION] with your own details. Everything in square brackets is a blank for you to fill in.
Paste it into your assistant
Checked against Mistral, ChatGPT, Claude. It is written as plain instructions, so paste it into whichever of them you already use.
Read the result, then push back
Compare what you get to the example below. If it is close but not right, say what to change: shorter, warmer, more specific, then ask again in the same conversation.
More prompts like this one
Close neighbours in Business & Productivity, by shared subject and tagging.
- Automate Personalized Email Sending with VBA
- Excel VBA Macro to Automate a Specific Spreadsheet Task
- Create Standardized Templates for Consistent Application
- Evaluate and Integrate New Software Development Methodology into Team Workflow
- Create a Comprehensive Mobile App Development Roadmap for a Startup
- Comprehensive SaaS Development and Sales Blueprint
Reviews and questions
What other people got out of this prompt, and what they asked about it.
Sign in to review this prompt.
Sign In to ReviewNo reviews yet
Be the first to share how this prompt worked for you.
Ask how to customize, adapt, or use this prompt more effectively.
Sign In to AskNo questions yet
Have a question about using or customizing this prompt? Be the first to ask.