Solved

Launching PPT from VB

Posted on 2003-10-24
3
285 Views
Last Modified: 2010-05-01
Hi All,
ICan someone help me with a Vb code which can launch a Power Point Macro from a
stand alone VB application. I have been stuck in this problem since long.
 
Thanks in advance,
Lonely
0
Comment
Question by:LonelyVB
  • 2
3 Comments
 
LVL 44

Accepted Solution

by:
bruintje earned 50 total points
ID: 9613359
you could try something like


Sub h()
Dim PPApp As Object
Dim myp As Object
Set PPApp = CreateObject("PowerPoint.Application")
PPApp.Visible = True
Set myp = PPApp.Presentations.Open("c:\temp\myprez.ppt")
PPApp.Run ("myprez.ppt!Module1.t")
End Sub

where
myprez is your presentation name
Module1 is your module name in the presentation
t is the name of the public sub you're calling

hope this helps a bit
0
 

Author Comment

by:LonelyVB
ID: 9614222
Hi Bruintje,
Thanks for the reply to my query.

I tried the code and it works wonderfully. I was able to launch the macro from my VB application. Thanks a million for the same.

Lonely
0
 
LVL 44

Expert Comment

by:bruintje
ID: 9615146
cool, glad you got it solved :)
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Determine Range to Select 5 53
How to make an ADE file by code? 11 94
Automatic Email Reminder 4 58
Error with a code discussed on this page 5 34
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question