How to close Power Point?

[daniel50096230]

I would like to export my Excel to PPT format...Before I export,I would like to close the existing Power Point that had been opened...How can I do it using VBA....

 

[Jonnyu182]

I use the code below to open powerpoint and close the active window before opening a new one and copying some graphs from excel in.

Dim PPapp As PowerPoint.Application
Dim PPPres As PowerPoint.Presentation
Dim PPSlide As PowerPoint.Slide

Set PPapp = CreateObject("PowerPoint.Application")
PPapp.Visible = True
On Error Resume Next
PPapp.ActivePresentation.Close
On Error GoTo 0

 

[daniel50096230]

Thanks...You help me alots...I appreciate your help....:D

 

[Stormseed]

Hi Jonny

Your signature makes more sense this way:

A train station is where the train starts. A bus station is where the bus starts. On my desk, I have a work station..