VBA 07 - slide side doesn't change
in [Powerpoint]
|
From: Edward on 11 Dec 2009 11:33 Hi everybody, I use the follwoing code to change the slide size ActivePresentation.PageSetup.SlideSize = ppSlideSizeLetterPaper or ActivePresentation.PageSetup.SlideSize =ppSlideSizeA4Paper it works fine in 03 but in 07 although it shows on the User Inteface page setup dialog box that size is changed , actually i doesn't change it and have no effect. Any suggestions? -- Best regards, Edward
From: John Wilson on 11 Dec 2009 12:17 "Edward" <Edward(a)discussions.microsoft.com> wrote in message news:902E9991-0297-4029-9DEC-C7D5E6027BCE(a)microsoft.com... > Hi everybody, > I use the follwoing code to change the slide size > ActivePresentation.PageSetup.SlideSize = ppSlideSizeLetterPaper > > or > ActivePresentation.PageSetup.SlideSize =ppSlideSizeA4Paper > > it works fine in 03 but in 07 although it shows on the User Inteface page > setup dialog box that size is changed , actually i doesn't change it and > have > no effect. > Any suggestions? > > -- > Best regards, > Edward > Works fine here Edward (in 2007 SP2) John __________ Information from ESET Smart Security, version of virus signature database 4679 (20091211) __________ The message was checked by ESET Smart Security. http://www.eset.com
From: Steve Rindsberg on 11 Dec 2009 13:15 In article <902E9991-0297-4029-9DEC-C7D5E6027BCE(a)microsoft.com>, Edward wrote: > Hi everybody, > I use the follwoing code to change the slide size > ActivePresentation.PageSetup.SlideSize = ppSlideSizeLetterPaper > > or > ActivePresentation.PageSetup.SlideSize =ppSlideSizeA4Paper > > it works fine in 03 but in 07 although it shows on the User Inteface page > setup dialog box that size is changed , actually i doesn't change it and have > no effect. I can repro this here. > Any suggestions? Take note of the sizes that it sets when you choose them manually for each page size you need. Then set the sizes explicitly in code rather than relying on the pagesize names. For example: With ActivePresentation.PageSetup .SlideWidth = 72 * 11.75 ' 11.75 in wide .SlideHeight = 72 * 7.5 ' by 7.5 in high End With ============================== PPT Frequently Asked Questions http://www.pptfaq.com/ PPTools add-ins for PowerPoint http://www.pptools.com/
From: Edward on 11 Dec 2009 13:38 Thanks. I use SP2 as well. What it does here is just changing the value in the PageSetup size dropdown , but it doesn't actually change the slide size. so if I save the PP and close and open it again it and look at the pagesize it's "On screen show". other properties of the Pagesetup work fine for example 07 responds to the following code ActivePresentation.PageSetup.SlideWidth=480 by changing the slide width on screen. You said it works for you. Is there any seetings that prevents my code working properily on my machine? -- Best regards, Edward "John Wilson" wrote: > > > "Edward" <Edward(a)discussions.microsoft.com> wrote in message > news:902E9991-0297-4029-9DEC-C7D5E6027BCE(a)microsoft.com... > > Hi everybody, > > I use the follwoing code to change the slide size > > ActivePresentation.PageSetup.SlideSize = ppSlideSizeLetterPaper > > > > or > > ActivePresentation.PageSetup.SlideSize =ppSlideSizeA4Paper > > > > it works fine in 03 but in 07 although it shows on the User Inteface page > > setup dialog box that size is changed , actually i doesn't change it and > > have > > no effect. > > Any suggestions? > > > > -- > > Best regards, > > Edward > > > Works fine here Edward (in 2007 SP2) > > John > > > __________ Information from ESET Smart Security, version of virus signature database 4679 (20091211) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > > . >
From: Edward on 11 Dec 2009 14:06 Thanks, Steve. Yes as I mentioned I can set all other properties except for the size. This code is part of procedure that based on users region selection(US or nonUS) authomatically changes the slide size from letter to A4. If I set width and height separately , the page size dropdown will display custom instead of letter or A4 , which is not a major problem , but still not perfect. If you can repro the same thing that means this a bug in 07. In 03 this code works fine. so I hopw MS will fix this. I wonder why it works for John Wilson ??? Thanks, -- Best regards, Edward "Steve Rindsberg" wrote: > In article <902E9991-0297-4029-9DEC-C7D5E6027BCE(a)microsoft.com>, Edward wrote: > > Hi everybody, > > I use the follwoing code to change the slide size > > ActivePresentation.PageSetup.SlideSize = ppSlideSizeLetterPaper > > > > or > > ActivePresentation.PageSetup.SlideSize =ppSlideSizeA4Paper > > > > it works fine in 03 but in 07 although it shows on the User Inteface page > > setup dialog box that size is changed , actually i doesn't change it and have > > no effect. > > I can repro this here. > > > Any suggestions? > > Take note of the sizes that it sets when you choose them manually for each page > size you need. Then set the sizes explicitly in code rather than relying on the > pagesize names. For example: > > With ActivePresentation.PageSetup > .SlideWidth = 72 * 11.75 ' 11.75 in wide > .SlideHeight = 72 * 7.5 ' by 7.5 in high > End With > > > ============================== > PPT Frequently Asked Questions > http://www.pptfaq.com/ > > PPTools add-ins for PowerPoint > http://www.pptools.com/ > > > . >
|
Next
|
Last
Pages: 1 2 Prev: Making 2007 toolbars (or the like) Next: Why is Close Group option greyed out? |