×

Cross-Application

Populate A PowerPoint Quiz From Excel With VBA

Populate A PowerPoint Quiz From Excel With VBA

A couple months ago I received an email from Titus who was looking for a way to easily populate and...

The VBA Guide To Sending Excel Attachments Through Outlook

The VBA Guide To Sending Excel Attachments Through Outlook

Quickly Emailing Your Spreadsheets I absolutely love using the Email As Attachment functionality provided by Excel. It's great for quickly...

Best Way To Paste Special Excel Objects As PowerPoint Images

Best Way To Paste Special Excel Objects As PowerPoint Images

Quality Matters I've written many times in the past on how the quality and formatting of your work can separate...

Copy & Paste Multiple Excel Tables Into Microsoft Word With VBA

Copy & Paste Multiple Excel Tables Into Microsoft Word With VBA

Moving Excel Tables Into Various Word Pages  This post is an add-on to a previous post I wrote covering how...

How To Filter Excel Data In A PowerPoint Presentation

How To Filter Excel Data In A PowerPoint Presentation

PowerPoint Filtering This was a great idea that came from a reader named Chris Morgan. He wanted to know if...

VBA Copy/Paste Multiple Excel Ranges To PowerPoint Slides

VBA Copy/Paste Multiple Excel Ranges To PowerPoint Slides

Stop Manually Copying and Pasting! This post is a continuation of the current most popular blog post on The Spreadsheet Guru...

VBA Copy/Paste An Image, Text, & Table (Excel to Word)

VBA Copy/Paste An Image, Text, & Table (Excel to Word)

Taking A Previous Post One Step Further This will build from a post I previously wrote entitled Copy & Paste An...

VBA To Copy/Paste Excel Table Into Microsoft Word

VBA To Copy/Paste Excel Table Into Microsoft Word

Moving An Excel Table Into A New Word Document In this post you will learn how to write VBA code...

VBA To Add A Confidentiality Footer Statement In Excel, Word, or PowerPoint

VBA To Add A Confidentiality Footer Statement In Excel, Word, or PowerPoint

What This VBA Code Does When handling sensitive data it is vital to display some sort of statement to let...

Copy & Paste An Excel Range Into PowerPoint With VBA

Copy & Paste An Excel Range Into PowerPoint With VBA

Why Do This? I've received a large number of questions on how to command other programs with VBA through Excel....

Teaching Excel How To Speak PowerPoint

Teaching Excel How To Speak PowerPoint

Teaching Excel How To Speak PowerPoint In order to control PowerPoint (or any other program) from inside Excel's Visual Basic...