• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 375
  • Last Modified:

library to include for MsoScaleFrom constants

Hi all, I am programming an
application that poduces Power Point slides.
Which references do I have to include in order
to have access to MsoScaleFrom constants and
other constants from power point (msoFalse, msoTrue, etc.)?

Thank you very much,

rr.
0
rrgw
Asked:
rrgw
  • 3
  • 3
  • 3
1 Solution
 
DhaestCommented:
How to make a powerpoint show in VB, and after show how to stop it?
o call a powerpoint presentation from vb:
Remark, the 5 seconds between each slide has to be defined in the powerpoint presentation self.

Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long

Button Code -

Private Sub btnKernel_Click()

    Dim sFile As String
    sFile = "C:\3-box.ppt"
    Call ShellExecute(hwnd, "Open", (sFile), "", App.Path, 0)

End Sub
0
 
DhaestCommented:
Another possibility: add a reference to the powerpoint object library in your project...

Dim appPPT As PowerPoint.Application
Set appPPT = PowerPoint.Application

Dim myPres As Presentation
Set myPres = Presentations.Open(FileName:="c:\My documents\pres1.ppt")
myPres.Windows(1).ViewType = ppViewSlideSorter

With ActivePresentation.SlideShowSettings
    .StartingSlide = 2
    .EndingSlide = 4
    .RangeType = ppShowSlideRange
    .AdvanceMode = ppSlideShowUseSlideTimings
    .LoopUntilStopped = True
    .Run
End With
0
 
DhaestCommented:
--> Display PowerPoint slide show within a VB form or control window

http://www.mvps.org/skp/vb/pptvbwnd.htm
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
rrgwAuthor Commented:
Hi Dhaest,

I programmed the second option, that is:

Dim appPPT As PowerPoint.Application
Set appPPT = PowerPoint.Application

etc.

The problem is: when I compile things like:

    With logo
        .IncrementTop 393.75
        .ScaleWidth 0.48, msoFalse, msoScaleFromTopLeft
        .ScaleHeight 0.48, msoFalse, _
 msoScaleFromBottomRight
end with

VB complains that constants msoFalse,
msoScaleFromTopLeft and msoScaleFromBottomRight
are undefined.

I am not worried about playing the presentation, because
it will be played afterwards. The program is just to
building the presentation, not playing it.

I found MSPPT.OLB in my disk. Do I have to include it
as a reference or something like that?
I already included the Microsoft PowerPoint 10.0 object library (it was there when VB complained). Is this MSPPT.OLB another one?

Thanks,

rr.
0
 
OHDev2004Commented:
instead of msoFalse use False or 0
instead of msoTrue use False or 1
OHDev2004
0
 
rrgwAuthor Commented:
Thanks OHDev2004, but what about the values of the MSOScaleFrom constants?
(msoScaleFromBottomRight, msoScaleFromMiddle, msoScaleFromTopLeft)

rr.
0
 
OHDev2004Commented:
Here are the values of these constants

msoScaleFromBottomRight =2
msoScaleFromTopLeft=0
msoScaleFromMiddle=1

Tip: if you want to know any value of any constant :
open PowerPoint - Tools Menu - Macro - Visual Basic Editor :
then in any event like the following:

Private Sub UserForm_Initialize()
Msgbox  msoScaleFromBottomRight
End Sub

This will show you the value of the COnstant :)
Thanks,,
OHDev2004
0
 
rrgwAuthor Commented:
Thank you, OHDev2004
0
 
OHDev2004Commented:
Ur welcome :)
OHDev2004
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now