Excel macro to close PowerPoint

**Tony Bender** · 10-09-2009, 12:19 AM

I have an Excel application that enables the user to export an Excel chart directly into PowerPoint. The macro to do this works fine provided PowerPoint wasn't already open.

I am trying to figure the code so when the Excel application opens - it automatically closes any open PowerPoint.ppt - if in fact there are any open PowerPoint.ppt.

Here's what I have so far but I'm getting errors

Please Login or Register  to view this content.

Can anyone point me in the right direction?

Thank you,

**teylyn** · 10-09-2009, 12:35 AM

Please read the forum rules and then edit your post to wrap code in code tags.

**Leith Ross** · 10-09-2009, 01:12 AM

Hello Tony Bender,

Welcome to the Forum!

To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.

Use the Bulletin Board Code Tags
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end of the last line.

To learn more about BB codes used in this forum, just click on the link below...

Bulletin Board Codes Tags

RolfJ · 10-09-2009, 02:31 AM

Give this code a try:

Please Login or Register  to view this content.

**Tony Bender** · 10-09-2009, 09:43 AM

Rolf, thank you very much...that did it

RolfJ · 10-09-2009, 02:20 PM

Glad this worked for you. When you have a moment I would appreciate it if you were to click on the 'Add to answerers reputation' icon in the right-upper corner in the dark-blue band above the post.

Best wishes,
Rolf Jaeger
SoarentComputing
http://soarentcomputing.com

Phone: 800.580.0068
Cell: 510.300.7462

**Tony Bender** · 10-09-2009, 02:20 PM

Rolf,

While this worked initially, when I had open PPT's, now when there are now open PPT's I get the following error:

Run time error 429
ActiveX Component can't create object

When I click on debug it highlights:
Set PPApp = GetObject(, "PowerPoint.Application.11") 'or .12'

In the references I have:
Microsoft ActiveX Data Objects 2.8 Library
Microsoft ActiveX Data Objects Recordset 2.8 Library
Microsoft ActiveX Plugin

Here's the code:

Please Login or Register  to view this content.

Should I put something like

Please Login or Register  to view this content.

Thanks Rolf,

RolfJ · 10-12-2009, 03:57 PM

Hi Tony:

sorry about the delayed response! By now you probably already figured this out by yourself. Yes, you should do exactly what you suggested: simply insert an On Error Resume Next statement before the GetObject statement. It would however be prudent to clear that error handling directive with an On Error Goto 0 statement after the GetObject statement. Hence the section of your code containing the GetObject statement should look like this:

Please Login or Register  to view this content.

**eyong123** · 01-23-2012, 03:50 AM

How can I open a powerpoint presentation and update all links to excel graphs using a macro. If possible how can I present in slide show mode after updating.
Thanks in advance for your help

**teylyn** · 01-23-2012, 06:15 AM

@eyong123:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.