powerpoint vba close presentation without saving

• Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers
• Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand
• OverflowAI GenAI features for Teams
• OverflowAPI Train & fine-tune LLMs
• Labs The future of collective knowledge sharing
• About the company Visit the blog

Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Get early access and see previews of new features.

Save & Close powerpoint through Excel VBA

Below is code that creates multiple charts based on defined names, then opens powerpoint files with those defined names and dumps in the charts. I have everything working except the last part: save and close the file.

I've marked in green my attempts at trying to save and close the files. Any help is appreciated!

• 1 Why are you using two methods to create a PPT application? Do you need to make use of two different PPT instances? –  Kyle Commented Jan 6, 2017 at 18:40
• 1 No, I was just trying different methods to open the PPT application, whatever worked i used –  Daruki Commented Jan 6, 2017 at 18:43
• If you assign parentage and declare specific variables for all the object types (and avoid Active... ) you'll have a much easier time writing the working code you desire. –  Scott Holtzman Commented Jan 6, 2017 at 18:46

2 Answers 2

Your code to save and close presentation should work properly. The only thing should be done is to put waiting function between saving and closing as closing line doesn't 'wait' for saving which is causing errors.

Function for waiting:

And afterwards you can use:

• Here waiting is important. We are likely to think the computer is so fast that it doesn't need time to save something. But without giving some time to the computer, the powerpoint application would abnormally crash because it can't close the presentation while saving it. –  konahn Commented Feb 26, 2019 at 6:02

I just tested the below which opens an instance of Powerpoint, makes it visible, creates a presentation, saves the presentation (path will need to be changed), quits the app and discharges the variable. Please let me know if this does not suit your needs.

• Thank you for your help! I didn't choose your answer as the other one was a quick fix to my problem, but I do appreciate you taking the time to help me!! –  Daruki Commented Jan 6, 2017 at 19:46

Your Answer

Reminder: Answers generated by artificial intelligence tools are not allowed on Stack Overflow. Learn more

Sign up or log in

Post as a guest.

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy .

Not the answer you're looking for? Browse other questions tagged vba excel powerpoint or ask your own question .

• The Overflow Blog
• The hidden cost of speed
• The creator of Jenkins discusses CI/CD and balancing business with open source
• Featured on Meta
• Announcing a change to the data-dump process
• Bringing clarity to status tag usage on meta sites
• What does a new user need in a homepage experience on Stack Overflow?
• Feedback requested: How do you use tag hover descriptions for curating and do...
• Staging Ground Reviewer Motivation

Hot Network Questions

• How cheap would rocket fuel have to be to make Mars colonization feasible (according to Musk)?
• Is there a way to prove ownership of church land?
• Is "She played good" a grammatically correct sentence?
• How can I make this equation look better?
• Plausible orbit to have a visible object slowly circle over the night sky
• Textile Innovations of Pachyderms: Clothing Type
• Flats on gravel with GP5000 - what am I doing wrong?
• The head of a screw is missing on one side of the spigot outdoor
• Starting with 2014 "+" signs and 2015 "−" signs, you delete signs until one remains. What’s left?
• What are the steps to write a book?
• Information theoretical interpretation of Free Energy
• Understanding the parabolic state of a quantum particle in the infinite square well
• How to extrude a profile along multiple curves keeping tilt equal between instances and sane normals?
• Is my magic enough to keep a person without skin alive for a month?
• What's the best format or way to generate a short-lived access token?
• What qualifies as a Cantor diagonal argument?
• What are the most common types of FOD (Foreign Object Debris)?
• Why does each leg of my 240V outlet measure 125V to ground, but 217V across the hot wires?
• Setting the desired kernel in GRUB menu
• Could a lawyer agree not to take any further cases against a company?
• I want to be a observational astronomer, but have no idea where to start
• How to fold or expand the wingtips on Boeing 777?
• Visual assessment of scatterplots acceptable?
• Can you move between an attack and the attack granted by Horde Breaker?

• Mark Forums Read
• View Site Leaders
• Knowledgebase
• Consulting Services
• PayPal Donation
• Advanced Search
• VBA Code & Other Help
• PowerPoint Help

Close PowerPoint with slide show end

• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread: Close PowerPoint with slide show end

Thread tools.

• Show Printable Version
• Linear Mode
• Switch to Hybrid Mode
• Switch to Threaded Mode
• View Profile
• View Forum Posts

Hi, I would like to close PowerPoint, not only the presentation, after the slide show ends. I guess that should be possible with the event SlideShowEnd, right? For some reason the event doesn't seem to happen or affect any action. What's wrong? As a class: Public WithEvents App As Application As a module: Sub application_SlideShowEnd(ByVal Pres As Presentation) Dim App As Application Set App = CreateObject("PowerPoint.Application") With App.Presentations("makro5.pptm") .Saved = False .Quit 'or .Close? End With End Sub Btw: It's impossible to call the macro application_SlideShowEnd. Is it cause it's an event which doesn't have to be called? André

You cannot fire an event like that. Private Sub App_SlideShowEnd(ByVal Pres As Presentation) End Sub Needs to be in the class module and you also need to instantiate a new instance In a normal module Public instAPP As New Class1 'whatever the class is named Sub Instantiate() Set instAPP.App = Application End Sub Note this cannot be auto run except in an AddIn unless you use the onLoad event in the ribbon http://www.pptalchemy.co.uk/PowerPoi...Open_Code.html IF you are running other macros a much easier (though a little less reliable way) is to use this in a normal module Sub OnSlideShowTerminate(SW as SlideShowWindow) SW.Parent.saved=True App.Quit ' You shouldn't recreate the App I presume you have already done so End Sub This will only run reliably if other macros are accessed during the show,

John Wilson Microsoft PowerPoint MVP Amazing Free PowerPoint Tutorials http://www.pptalchemy.co.uk/powerpoi...tutorials.html

So far I'm running a macro by onload. Did I get it right that for this reason I won't need the class module? Do you mean IF I've "dim-ed" App in the class module? Either way (with App-dimming class module or without) it doesn't quit PowerPoint so far. Originally Posted by John Wilson You shouldn't recreate the App I presume you have already done so This will only run reliably if other macros are accessed during the show I run the macros of my two first threads before the show starts, but none while the show is running. Is this the issue? Or do I have to dim App in another macro? Or in the OnSlideShowTerminate macro? I suppose I'm quite off the track atm...

If you run ANY macro it should work OK. If you are doing all of this in PowerPoint there's no need to Dim App at all. By default the Application is taken to be the open application. Application.Quit If you really want to be sure PowerPoint.Application.Quit

Works. Nice! Thank you Is there any way to open the marco editor (or the normal view) without disabling macros?

I've changed the last line to ActivePresentation.Close. This way the users will be able to disable macros if they want to. What's good SW.Parent.Saved = True for? I tought it might be pretending the document has been saved to prevent the Save as dialog. But there is no change without that line. Does it actually save the file? The opposite would be nice. But if this line saves the file, I'd just have to leave out this line, cause as said, it doesn't seem to take any effect.

SW.Parent.Saved = True Just makes sure the Save dialogue doesan't pop up. Some macros convince ppt that changes have been made and therefore it needs to save before close.

Yeh, just recognized it after turning off the close-line

• Private Messages
• Subscriptions
• Who's Online
• Search Forums
• Forums Home
• Announcements
• Introductions
• How to Get Help
• Non English Help
• Access Help
• SUMPRODUCT And Other Array Functions
• Outlook Help
• Office 2007 Ribbon UI
• Integration/Automation of Office Applications Help
• Other Applications Help
• Testing Area
• Mac VBA Help
• Other Mac Issues
• Book Reviews

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
• BB code is On
• Smilies are On
• [IMG] code is On
• [VIDEO] code is On
• HTML code is Off

Forum Rules

• VBA Express
• Privacy Statement

AutoMacro: Ultimate VBA Add-in

Read all reviews

Return to VBA Code Examples

PowerPoint VBA Macro Examples & Tutorial

Editorial Team

Reviewed by

Steve Rynearson

In this Article

VBA PDF (Free Downloads)

Save as macro-enabled presentation, enable ‘developer’ tab in the ribbon, create powerpoint macro, powerpoint application, open a new presentation, open an existing presentation, open and assign to a variable, refer to active presentation, save current presentation, close current presentation, useful references, assign existing presentation (by name) to variable, assign active slide to variable, assign slide by index to variable, count number of slides, get slide index number of current slide, add a blank slide to end of slide show, add a slide after current slide, delete a slide, go to a specific slide, loop through all slides, loop through all shapes of active slide, loop through all shapes in all slides, loop through all textboxes of active slide, loop through all textboxes in all slides, copy selected slides to new ppt presentation, copy active slide to end of active presentation, change slide during slide show, change font on all slides in all textboxes, change case from upper to normal in all textboxes, toggle case between upper and normal in all textboxes, remove underline from descenders, remove animations from all slides, save presentation as pdf, find and replace text, export slide as image, resize image to cover full slide, exit all running slide shows, open powerpoint – early binding, open powerpoint – late binding, make application visible, maniplulate powerpoint, close the application, copy from excel to powerpoint, powerpoint vba faqs.

This is a complete guide to automating PowerPoint using VBA (Visual Basic for Applications) Macros.  Below you will find many useful examples.

Download our free Microsoft PowerPoint VBA Tutorial! Or VBA Tutorials for other Office Programs!

PowerPoint VBA (Macros) Tutorial

The Presentation with VBA code should be ‘Saved As’ PowerPoint Macro-Enabled Presentation (*.pptm)

You should to enable the Developer tab on the Ribbon before creating VBA code. To do so choose File -> Options then click on ‘Customize Ribbon’ and check the box next to ‘Developer’ tab in the right pane.

This is a simple example of a PowerPoint VBA Macro:

It saves the active presentation as a PDF. Each line of code does the following:

• Creates variables for the PowerPoint name and PDF name
• Assigns the active presentation name to pptName variable
• Creates the full PDF name
• Saves the presentation as a PDF

When VBA code is running within a PowerPoint Presentation, PowerPoint Application is the default application and it can be manipulated without explicitly reference. Create a New Presentation

To create a presentation, use the Add method of PowerPoint application.

To open a new and blank presentation use the Add method of Application.Presentations collection

To open a presentation which you have already created, use the Open method of Application.Presentations collection

The code above assumes that the presentation is in the same directory as the PowerPoint Presentation containing the code.

You should assign the presentation you open to a variable so that you can manipulate it as per your requirements.

Use the reference ActivePresentation to manipulate the Presentation active in the GUI when the VBA code is executed.

The statement below will save the Active Presentation if it was saved before. It it has not been saved then you will be prompted with the ‘Save As’ dialog.

The statement below will close the Active Presentation even if it was not saved after the last edit.

You can move a slide from its old position to the new position

You can do something with each slide or go through all slides to find a few slides and do something about with using the code;

The power of PowerPoint can be realized by using ‘Shapes.’ The code below loops through all the shapes on the current slide so that you can manipulate them as you want;

You can loop through all the shapes in the presentation by adding a loop to go through all slides.

TextBoxes are the most often used Shape in PowerPoint presentations. You can loop through all the Text Boxes by adding a check for ‘Shape Type.’ TexBoxes have the shape type defined as the VBA constant msoTextBox (the numerical value of the constant is 17)

Again, you can loop through all the textboxes in the presentation by adding a loop to go through all slides.

To copy certain slides to a new presentations, first select the desired slides in the existing presentation and then run the code below;

Useful PowerPoint Macro Examples

Here are some useful macro examples showing how to do tasks. These will also demonstrate the concepts described above.

In typography, a descender is the portion of a letter that extends below the baseline of a font. In most fonts, descenders are reserved for lowercase characters such as g, j, q, p, y, and sometimes f.

When you underline text, it does not look nice under descenders. Here is the code to remove underline from all such characters g, j, p, q, and y in the whole Presentation.

Use the code below to remove all animations set in a Presentation.

You can easily save Active Presentation in PDF format.

You can find and replace text in All TextBoxes of All Slides. After the fist instance of the text you want to find (defined by findWhat) you need to loop through the Find command to find other instances, if any.

You can export Current SLide (or any other slide) as a PNG or JPG (JPEG) or BMP image.

If you have multiple Slide Shows open at the same time then you can close all of them using the macro below.

Automating PowerPoint from Excel

You can also connect to PowerPoint though other applications (like Excel and Word). As as first step, you must refer to an instance of PowerPoint.

There are two ways of doing it – early binding and late binding .

In ‘Early Binding’ you must explicitly set a reference to ‘Microsoft PowerPoint 16 Object Library’ (for MS Office 2019) in the VBE (Visual Basic Editor) using the option Tools->References.

In ‘Late Binding’ application variable is declared as an object and VBA engine connects to the correct application at run time.

After setting the reference to PowperPoint application, you may need to make it visible.

You can use all the methods to manipulate presentations, from within PowerPoint, described above from Excel by just adding the reference to PowerPoint created by you above.

For example

has to be used liked this

Once you have completed what you wanted to do with the PowerPoint application you must close it and should release the reference.

This code will copy a range from Excel to PowerPoint:

Note : It has been kept as simple as possible to show how a range from Excel can be copied to PowerPoint using VBA.

What are macros in PPT?

A Macro is a general term that refers to a set of programming instructions that automates tasks. PowerPoint (PPT) Macros automate tasks in PowerPoint using the VBA programming language.

How do I use VBA in PowerPoint?

To use VBA in PowerPoint, open the VBA Editor (ALT + F11 or Developer > Visual Basic).

How do I create a Macro in PowerPoint?

1. Open the VBA Editor (ALT + F11 or Developer > Visual Basic) 2. Go to Insert > Module to create a Code Module 3. Type ‘Sub HelloWorld’ and press Enter 4. In between the lines ‘Sub HelloWorld’ and ‘End Sub’, type ‘MsgBox “Hello World!’ 5. You’ve created a Macro! 6. Now press ‘F5’ to run the Macro

Written by: Vinamra Chandra

VBA Code Examples Add-in

Easily access all of the code examples found on our site.

Simply navigate to the menu, click, and the code will be inserted directly into your module. .xlam add-in.

(No installation required!)

Free Download

AutoMacro: VBA Add-in with Hundreds of Ready-To-Use VBA Code Examples & much more!

• Search forums
• Board Rules

Follow along with the video below to see how to install our site as a web app on your home screen.

Note: This feature may not be available in some browsers.

• If you would like to post, please check out the MrExcel Message Board FAQ and register here . If you forgot your password, you can reset your password .
• Question Forums
• Excel Questions

Excel VBA code to close powerpoint presentations

• Thread starter Angribob
• Start date Jun 21, 2011
• Jun 21, 2011

Hi all, does anyone have an excel vba code that can detect how many open powerpoint presentations there are and then close them all (with or without saving)? Would be fantastic if anyone does any wouldn't mind sharing!! I'm struggling to write one. thanks, Bob  

Excel Facts

Similar threads.

• tbakbradley
• Aug 17, 2024
• Jul 5, 2024
• noobslayer252
• Jan 11, 2024
• Jul 21, 2024

• Apr 8, 2024

Forum statistics

Share this page.

We've detected that you are using an adblocker.

Which adblocker are you using.

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

DocumentWindow.Close method (PowerPoint)

• 7 contributors

Closes the specified document window.

expression . Close

expression A variable that represents a DocumentWindow object.

When you use this method, PowerPoint will close an open presentation without prompting users to save their work. To prevent the loss of work, use the Save method or the SaveAs method before you use the Close method.

This example closes all windows except the active window.

DocumentWindow Object

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

Was this page helpful?

Additional resources

Complete VBA tutorial to interact with Power point Presentations – Part – 1

Excel macro tutorial.

[fusion_text] D

ear Friends,

First of all, I apologize for not responding to many of your questions around dealing with PowerPoint presentations through Excel Macro. Many of you have sent me so many questions around this topic. Questions, which were, mostly, asked were like –

Sample List of Questions…

  VBA code to create a presentation slide based on a Table in Excel   Excel macro to create a Slide with Graph and Table in Excel   Macro to paste Graph from Excel in to a PPT in a specific Slide   VBA code to remove old graph from a specific slide and place the new generated graph in Excel – Like refresh button

This list i just a summary what has been asked so far. Many of the questions were too specific, hence I have not mentioned them here. Therefore, I thought of writing a tutorial (more than a single article) and cover most of the aspects related to interaction with PowerPoint presentations through Exel VBA. Rather putting everything in one article, I am splitting in to more than one article. As part of this tutorial, I am sure, you will learn all the basic things (regular things) to interact with PowerPoint Presentations through Excel VBA. Furthermore, you will have readily available VBA code snippets for all the basic operations, one can perform on Presentations like Open, Close, save, Copy a slide from one Presentation to other, deleting a slide, modifying the content of the slide and so on.. Finally, at the end of this tutorial , you will find a FREE Excel VBA tool to download . Mostly in the next article of this tutorial.

Topics covered in this Article

Click on the links to directly jump to that particular section…

  Basics about Power Point Application Object Model in Excel VBA

  vba code to create a new presentation (power point presentation file),   vba code to add slides in ppt,   vba code to save a new ppt – saveas statement,   vba code to open an existing presentation file,   vba code to save an existing presentation file – save statement,   vba code to save and close powerpoint presentation,   vba code to delete slides in ppt.

Since we are going to access an application which is out side Microsoft Excel. Therefore to interact with that application you should have a good understanding of Objects and Methods of that application. Here in this article I am NOT going to explain you about all the Objects, Methods and Properties of PowerPoint Application but few of them to make you comfortable. To know all possible Objects, Methods, Properties and their hierarchy you can refer this page: http://msdn.microsoft.com/en-us/library/office/aa213568(v=office.11).aspx .  

VBA to Create a New Power Point Application

To start with any operation with any kind of PowerPoint file, you need to create an Object for the application itself. Therefore your code will always start with a statement to create an Object for PowerPoint Application:

As soon as the above line of statements are executed you can see a Power Point File launched which will look like below:

As you can see in the above image only a simple Application is launched. It has no placeholder for presentations and Slides. This is because you have just created an Application Object.

Now we have an Application Object so we can create multiple Presentation File from this.

Above code snippet will add 2 presentations (2 PowerPoint files) as you can see in the below images:

But these presentations will be looking something like below – an Empty Presentations without any Slide in it.

Power Point Presentation Object

As you can see in the above image, there is no slide. Now let us see how to add a slide in a presentation created above.

VBA code to add slides to PowerPoint Presentation

In the above example you had added two new presentations with no slide. As you already know, each presentation file may contain multiple slides in it. That means, a Presentatio Object holds a collection of Slides. This means…You can add slides to Slides collection using .Add method of Slides object (Collection of Slide). Refer the Syntax of this method below

Syntax of .Add Method

.Add method belongs to Slides Object. [highlight color=”yellow”]MyPresentation1.Slides.Add <Index Number> , <Layout of the slide>[/highlight]

Index Number: Slides is basically a collection of all Slide Object, a Presentation has it. Therefore to add a slide in Slides collection, you need to pass the index number which tells the position of the new slide in Slides collection. In simple terms, this indicates the position of your Slide in your PowerPoint Presentation. For example: If you pass Index number as 3 then new slide will be added at 3rd position, no matter how many more slides are there. But if total number of slides are less than 2 and you passed index as 3 then it will throw an error.

Layout of the slide: This basically tells the type of Layout you want for your new slide. There is a list of around more than 20 layout type which you can use it for Power Point 2007. You can pass the exact VBA name of a layout or just an integer number (depending on the version of the Office you have in your computer)

Save & Close PowerPoint Through Excel VBA

Let’s have a look – on how to save and close a power point presentation using Excel VBA. .Save and .Close is the keywords to save and close a presentation respectively. These methods belongs to Presentation Object.

In case you want to save your presentation with a different name or at different location then you can use .SaveAs method. The only difference in both these methods is – For .Save you do not need to provide file path but for .SaveAs it is mandatory to provide the file path. Refer below code.

What did we learn so far?

1. How to create Power Point Application , Presentations and Slides Objects 2. How to create new Power Point Presentations 3. How to add slides to power point presentation 4. How to Save and Close Presentations in Excel VBA

VBA to Create a New Power Point Presentation

As I have explained above, I will club all the lines of code with some more statements together and form a single code which will do the following :

1. Create 2 New Power Point File 2. Add 5 slides in one presentation and 3 in second one. 3. Save these power point presentation files on your desktop

  You have learnt above, how to create a new Powerpoint presentation with multiple slides in it, save and close it. Now I will teach you how to open an existing Power Point file using Excel VBA

Excel VBA to open PowerPoint Presentation File

First you need to create a PowerPoint Application object which will actually hold your opened presentation file. If you do not have a valid Power Point Application object then you can not open your presentation file directly.

To open a presentation you can use the below statement:

objNewPowerPoint – is your defined Power Point Application Object FilePath – This is the complete path of the file with file name with file extension

Above statement opens a presentation file which is a Presentation Object. Therefore we should assign this to a unique object so that at any point of program we can refer this presentation uniquely.

Now you can use MyPresentation3 presentation object to add slides to it, delete, save, close etc. same as the above code.

Now let us create an example with everything we learnt so far. In this example, I am going to do the following:

1. open an Existing power point presentation 2. Add a Slide at 3rd position (make sure that the file you choose, has, at least 2 slides other wise it will through as an exception as explained above) 3. Save and close the presentation

Important: Difference between Save and SaveAs

In the first example as well we saved one presentation. But in this example Save is different. If you notice in the first example we had used SaveAs because it was a new file and we have to give a valid path and name to save it but in this example this file is already saved in a particular location with a name from where you have opened it.

Therefore in this case you can simply run the Save command which will save the changes you made in that presentation. But if you still want to save this as a different file name or location you can go ahead with SaveAs command. Save As is same as the save as command in any file.

VBA Code to delete slide from PowerPoint Presentation

.Delete method is used to delete a single slide from Slide collection. This method belongs to a single Slide Object. You must identify a single slide item from Slides collection before deleting it.

pSlides(slideNumber).Delete

pSlides.Item(slideNumber).Delete

pSlides : Variable of Slides type where Slide collection of the presentation stored from which slides has to be deleted

slideNumber : As the name says.. Slide number which you want to delete. Like for 1st Slide – 1, for second – 2 and so on..

Important Point

While adding a new slide, we add it in the collection (Slides), therefore .Add method belongs to Slides collection. But, while deleting a slide, we delete individual slides from the collection, therefore .Delete is a method of Slide object -> (Slides.Item(i))

About the Next Article…

In this article I will cover the following: 1. Create Power Point Presentations by creating the Object using CreateObject keyword. 2. Some Useful and practical Examples

Buy a coffee for the author

Get a FREE e-Book

With over  50,000+  readers and counting  Join NOW and get a  FREE E-book  to download !!

You have Successfully Subscribed!

Download FREE Tools and Templates

There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.

Dynamic Arrays and Spill Functions in Excel: A Beginner’s Guide

Feb 9, 2024

In today's tutorial, we'll be diving into the exciting world of dynamic arrays and spill functions in Office 365 Excel. These features have revolutionized the way we work with data, providing a more flexible and efficient way to handle arrays. I am going to explain...

How to Declare a Public Variable in VBA

Feb 3, 2024

While programming in VBA sometimes you need to declare a Public Variable that can store the value throughout the program. Use of Public Variable: Let's say you have 4 different Functions in your VBA Code or Module and you have a variable that may or may not be...

How to Copy content from Word using VBA

As many of us want to deal with Microsoft Word Document from Excel Macro/VBA. I am going to write few articles about Word from Excel Macro. This is the first article which opens a Word Document and read the whole content of that Word Document and put it in the Active...

What is Excel Formula?

Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).

You May Also Like…

How to connect to access database – ado connection string.

Using Excel Macros (VBA) you can connect to any Databases like SQL, Oracle or Access DB. In this Article you will...

ADO RecordCount Property – RecordSet Object

The RecordCount property returns a long value that indicates the number of records in a Recordset object. Many a times...

How to Get Excel version using VBA Code

Feb 2, 2024

Dear Friends, Usually while working on any of the VBA projects, it becomes important for me to first check the version...

Hi, My name is Faiz. I need your help to consolidate multiple ppt slides in a single slide but condition is that multiple name in a excel sheet. how to consolidate according to Name wise(Name is available in excel sheet).plz help me to create this code.

Thanks, Faiz

Hi Faiz, Have you got your answer ? If yes, reply with the code so that others can also learn from yours.

Otherwise attach a sample file with your requirement.

I am getting an run time error while opening ,save as and closing PowerPoint using excel vba. Need help its urgent

thanks in advance

Trackbacks/Pingbacks

• Welcome to LearnExcelMacro.com Interacting with Powerpoint Slides – Tutorial – Part 2 (Last) - […] is a continuation of my previous article about Interaction with Power point Slides using Excel Macro. In my previous…
• Complete VBA tutorial to interact with Power point Presentations - Part - 2 - […] is a continuation of my previous article about Interaction with Power point Slides using Excel Macro. In my previous…

Submit a Comment Cancel reply

Your email address will not be published. Required fields are marked *

Save my name, email, and website in this browser for the next time I comment.

Submit Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed .

Join and get a FREE! e-Book

Don't miss any articles, tools, tips and tricks, I publish here

Pin It on Pinterest