Calling Power Point Page from Ms Access

[101287]

Can someone provide me some guidance? Need to be able to link to a power point page in access. Is there a way to do that?

I have the directory of the power point but would like to be able to go to specific table.

Can someone provide me a URL to learn how to do that or share VBA code in MS Access that do that fuction.

Your assistance and collaboration will be appreciated.

Luis

 

[bartrein]

Hi Luis

You can use something along these lines in your access code module:

First you will need to setup a reference to
Microsoft Powerpoint 11.0 Object Library (VB Editor/Tools/References)

Sub OpenPPTPresentation()

Dim ppApp As PowerPoint.Application
Dim sYourPPTFile As String

sYourPPTFile = "E:\manuals\Fixed Income Presentation.ppt"
Set ppApp = New PowerPoint.Application
ppApp.Visible = True

ppApp.Presentations.Open Filename:=sYourPPTFile, ReadOnly:=msoFalse

'code to select your page ....etc

End Sub

Remember that you can record macros in powerpoint and use/modify produced code in your access macros.

 

[101287]

Thank bartrein. The information give me a good start. By the way do you have a URL that can provide me additional information regarding the code for the page.

Luis

 

[bartrein]

I don't have much experience with PP object but the following line will take you to your page providing you know it's number (in this case it goes to slide no 4) :

ActivePresentation.Slides(4).Select

Maybe someone else can recommend you a good website for VBA with Powerpoint.