Launch PowerPoint File Using MS-Access Form Button

[Brian B]

I currently have a form button to launch a PowerPoint slide by including the
UNC to the PPT in the Hyperlink Address. This opens the file in slide-show
mode. Is there an option that will open it in 'normal' mode using the
subaddress, etc.? Is there a better way of opening the file using code?

Thanks, Brian.

 

[Danny Lesandrini]

Are you using / have you tried ... Application.FollowHyperlink ?

 

[Brian B]

Using the following code still launches me into PowerPoint Slide Show, not
the 'normal' view. I want the latter because I want to open and edit my
powerpoint, not just click and present... All other ideas welcome. Tks, Brian.

Private Sub btnPowerPointTest_Click()
On Error GoTo Err_btnPowerPointTest_Click

Dim stAppName As String

stAppName = "\\Hos2kdclim1\metrics\ActionLimits\Validation\Action Limit
Review - Validations.ppt"
Application.FollowHyperlink stAppName, , True


Exit_btnPowerPointTest_Click:
Exit Sub

Err_btnPowerPointTest_Click:
MsgBox Err.Description
Resume Exit_btnPowerPointTest_Click

End Sub