Solved

library to include for MsoScaleFrom constants

Posted on 2004-05-02
9
338 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
ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

 

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 50 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access query that references subform 5 47
How to make an ADE file by code? 11 86
Help me. 3 55
Need Nag Screen for Reboot if system up time is over 14 days 12 49
There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

777 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