Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

library to include for MsoScaleFrom constants

Posted on 2004-05-02
9
Medium Priority
?
363 Views
Last Modified: 2013-12-26
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
Comment
Question by:rrgw
  • 3
  • 3
  • 3
9 Comments
 
LVL 53

Expert Comment

by:Dhaest
ID: 10975056
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
 
LVL 53

Expert Comment

by:Dhaest
ID: 10975059
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
 
LVL 53

Expert Comment

by:Dhaest
ID: 10975064
--> Display PowerPoint slide show within a VB form or control window

http://www.mvps.org/skp/vb/pptvbwnd.htm
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:rrgw
ID: 10975171
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
 
LVL 7

Expert Comment

by:OHDev2004
ID: 10975841
instead of msoFalse use False or 0
instead of msoTrue use False or 1
OHDev2004
0
 

Author Comment

by:rrgw
ID: 10994838
Thanks OHDev2004, but what about the values of the MSOScaleFrom constants?
(msoScaleFromBottomRight, msoScaleFromMiddle, msoScaleFromTopLeft)

rr.
0
 
LVL 7

Accepted Solution

by:
OHDev2004 earned 200 total points
ID: 10996124
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
 

Author Comment

by:rrgw
ID: 11001497
Thank you, OHDev2004
0
 
LVL 7

Expert Comment

by:OHDev2004
ID: 11004277
Ur welcome :)
OHDev2004
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

916 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