running application.presentations.open Filename

P

Paddy

I have a vb generated index with links to powerpoints presentations.

I need the hyperlink to open the presentation and to run a macro.

Here is what I have so far but I am unsure where or how to add the last line
of code so that the linked powerpoint is controlled by the application and on
open witll run the macro.


Set oApp = CreateObject("Powerpoint.Application")
oApp.Visible = True
ActivePresentation.Slides("A-02-L1").Shapes("Rectangle
3").TextFrame.TextRange _
.Lines(1, 1).text = "Test Link"
With ActivePresentation.Slides("A-02-L1").Shapes("Rectangle
3").TextFrame.TextRange _
.ActionSettings(ppMouseClick).Hyperlink
.Address = ".\A-04.ppt"
.TextToDisplay = "Test Link"
End With

This is the line of code I need the hyperlink to execute
'Application.Presentations.Open ("A-04.ppt")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top