![]() |
|
|
|||
|
guides in ppt file - VBA
Hi,
I want to know where in ppt, the guides are stored. They are accessible from View > Grid and Guides > Display drawing guides on screen. I think they are ppt specific and not powerpoint specific. I need where they are stored as I need to copy that information from source ppt to destination ppt thru' VBA. Thanks, Savan |
|
|||
|
Re: guides in ppt file - VBA
In article <ekshAOL7IHA.1592@TK2MSFTNGP04.phx.gbl>, Savan Gandhi wrote:
> Hi, > I want to know where in ppt, the guides are stored. They are > accessible from View > Grid and Guides > Display drawing guides on screen. I > think they are ppt specific and not powerpoint specific. I need where they > are stored as I need to copy that information from source ppt to destination > ppt thru' VBA. The guides are ppt-specific, that's correct. Each presentation can have its own set of guides. But as far as I know, the guide settings are not exposed to VBA, so there may not be any way of accessing them directly. On the other hand, if you look at Tools, Macro, Script Editor and view the pres.xml file, you'll see the guides stored there. And you can one way or another manipulate the html programmatically, so that might be workable. ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Live and in personable in the Help Center at PowerPoint Live Sept 21-24, San Diego CA, USA www.pptlive.com |
|
|||
|
Re: guides in ppt file - VBA
Take a look at this article, it may help
How to retrieve guide information http://skp.mvps.org/pptxp008.htm Regards, Shyam Pillai Handout Wizard http://skp.mvps.org/how "Savan Gandhi" <savan_gandhi@persistent.co.in> wrote in message news:ekshAOL7IHA.1592@TK2MSFTNGP04.phx.gbl... Hi, I want to know where in ppt, the guides are stored. They are accessible from View > Grid and Guides > Display drawing guides on screen. I think they are ppt specific and not powerpoint specific. I need where they are stored as I need to copy that information from source ppt to destination ppt thru' VBA. Thanks, Savan |
|
|||
|
Re: guides in ppt file - VBA
Thanks Steve,
By manipulating HTMLProject property of presentation, I am able to copy the drawing guides thru' VBA. Thanks once again, Regards, Savan "Steve Rindsberg" <abuse@localhost.com> wrote in message news:VA.000041b6.3342d58e@localhost.com... > In article <ekshAOL7IHA.1592@TK2MSFTNGP04.phx.gbl>, Savan Gandhi wrote: >> Hi, >> I want to know where in ppt, the guides are stored. They are >> accessible from View > Grid and Guides > Display drawing guides on >> screen. I >> think they are ppt specific and not powerpoint specific. I need where >> they >> are stored as I need to copy that information from source ppt to >> destination >> ppt thru' VBA. > > The guides are ppt-specific, that's correct. Each presentation can have > its > own set of guides. But as far as I know, the guide settings are not > exposed to > VBA, so there may not be any way of accessing them directly. > > On the other hand, if you look at Tools, Macro, Script Editor and view the > pres.xml file, you'll see the guides stored there. And you can one way or > another manipulate the html programmatically, so that might be workable. > > > ----------------------------------------- > Steve Rindsberg, PPT MVP > PPT FAQ: www.pptfaq.com > PPTools: www.pptools.com > ================================================ > Live and in personable in the Help Center at PowerPoint Live > Sept 21-24, San Diego CA, USA > www.pptlive.com > |
|
|||
|
Re: guides in ppt file - VBA
Thanks Shyam,
Your code was extremely helpful. I am able to copy the drawing guides by using HTMLproject property. Thanks once again, Regards, Savan "Shyam Pillai" <ShyamPillai@Gmail.com> wrote in message news:eVoG5bO7IHA.2348@TK2MSFTNGP06.phx.gbl... > Take a look at this article, it may help > > How to retrieve guide information > http://skp.mvps.org/pptxp008.htm > > Regards, > Shyam Pillai > > Handout Wizard > http://skp.mvps.org/how > > "Savan Gandhi" <savan_gandhi@persistent.co.in> wrote in message > news:ekshAOL7IHA.1592@TK2MSFTNGP04.phx.gbl... > Hi, > I want to know where in ppt, the guides are stored. They are accessible > from View > Grid and Guides > Display drawing guides on screen. I think > they are ppt specific and not powerpoint specific. I need where they are > stored as I need to copy that information from source ppt to destination > ppt thru' VBA. > > Thanks, > Savan |
|
|||
|
Re: guides in ppt file - VBA
Copy of "drawing guides" from one ppt to another is successful. However, I
have one more sub-query in it. When I call HTMLProject.RefreshDocument(True), the screen flickers showing the ppt file and the presentation object reference gets lost (disposed). I am able to restore the ppt reference by initially storing its name in one string variable & then getting it thru' presentations collection. Inspite of using this thru' VBA, calling this method makes screen flicker. I think I can't avoid calling this method, otherwise the document does not get refreshed. Is there any other alternative to overcome screen flickering? Regards, Savan "Savan Gandhi" <savan_gandhi@persistent.co.in> wrote in message news:uuuVL0h7IHA.3724@TK2MSFTNGP03.phx.gbl... > Thanks Shyam, > Your code was extremely helpful. I am able to copy the drawing guides by > using HTMLproject property. > > Thanks once again, > Regards, > Savan > "Shyam Pillai" <ShyamPillai@Gmail.com> wrote in message > news:eVoG5bO7IHA.2348@TK2MSFTNGP06.phx.gbl... >> Take a look at this article, it may help >> >> How to retrieve guide information >> http://skp.mvps.org/pptxp008.htm >> >> Regards, >> Shyam Pillai >> >> Handout Wizard >> http://skp.mvps.org/how >> >> "Savan Gandhi" <savan_gandhi@persistent.co.in> wrote in message >> news:ekshAOL7IHA.1592@TK2MSFTNGP04.phx.gbl... >> Hi, >> I want to know where in ppt, the guides are stored. They are accessible >> from View > Grid and Guides > Display drawing guides on screen. I think >> they are ppt specific and not powerpoint specific. I need where they are >> stored as I need to copy that information from source ppt to destination >> ppt thru' VBA. >> >> Thanks, >> Savan > > |
|
|||
|
Re: guides in ppt file - VBA
Thanks for your help. One more question is:
when I try to access "pres.xml" file from HTMLProject (presentation property) it takes around 80 sec for a ppt file of 100 slides. Do we have other alternative from performance perspective? sourcePres.HTMLProject.HTMLProjectItems.Item("pres .xml").Text // this is taking 80 sec for 100 slide ppt Thanks, Savan "Savan Gandhi" <savan_gandhi@persistent.co.in> wrote in message news:ekshAOL7IHA.1592@TK2MSFTNGP04.phx.gbl... Hi, I want to know where in ppt, the guides are stored. They are accessible from View > Grid and Guides > Display drawing guides on screen. I think they are ppt specific and not powerpoint specific. I need where they are stored as I need to copy that information from source ppt to destination ppt thru' VBA. Thanks, Savan |
|
|||
|
Re: guides in ppt file - VBA
When you use the HTMLProject object, you are using the Script editor which
needs to be loaded and the time is directly proportional to the number of slide in the project. Regards, Shyam Pillai Image Importer Wizard http://skp.mvps.org/iiw.htm "Savan Gandhi" <savan_gandhi@persistent.co.in> wrote in message news:eH4FMfl7IHA.1420@TK2MSFTNGP06.phx.gbl... Thanks for your help. One more question is: when I try to access "pres.xml" file from HTMLProject (presentation property) it takes around 80 sec for a ppt file of 100 slides. Do we have other alternative from performance perspective? sourcePres.HTMLProject.HTMLProjectItems.Item("pres .xml").Text // this is taking 80 sec for 100 slide ppt Thanks, Savan "Savan Gandhi" <savan_gandhi@persistent.co.in> wrote in message news:ekshAOL7IHA.1592@TK2MSFTNGP04.phx.gbl... Hi, I want to know where in ppt, the guides are stored. They are accessible from View > Grid and Guides > Display drawing guides on screen. I think they are ppt specific and not powerpoint specific. I need where they are stored as I need to copy that information from source ppt to destination ppt thru' VBA. Thanks, Savan |
|
|||
|
Re: guides in ppt file - VBA
In article <e$Wa4om7IHA.1468@TK2MSFTNGP05.phx.gbl>, Shyam Pillai wrote:
> When you use the HTMLProject object, you are using the Script editor which > needs to be loaded and the time is directly proportional to the number of > slide in the project. As an alternative, save to HTML, work with the saved files, open the HTML back into PPT. This may or may not be faster, but a quick manual save then re-open (as HTML) of the 80-slide presentation would give some idea of the speed difference. > > Regards, > Shyam Pillai > > Image Importer Wizard > http://skp.mvps.org/iiw.htm > > "Savan Gandhi" <savan_gandhi@persistent.co.in> wrote in message > news:eH4FMfl7IHA.1420@TK2MSFTNGP06.phx.gbl... > Thanks for your help. One more question is: > when I try to access "pres.xml" file from HTMLProject (presentation > property) it takes around 80 sec for a ppt file of 100 slides. Do we have > other alternative from performance perspective? > > sourcePres.HTMLProject.HTMLProjectItems.Item("pres .xml").Text // this is > taking 80 sec for 100 slide ppt > > Thanks, > Savan > "Savan Gandhi" <savan_gandhi@persistent.co.in> wrote in message > news:ekshAOL7IHA.1592@TK2MSFTNGP04.phx.gbl... > Hi, > I want to know where in ppt, the guides are stored. They are accessible from > View > Grid and Guides > Display drawing guides on screen. I think they are > ppt specific and not powerpoint specific. I need where they are stored as I > need to copy that information from source ppt to destination ppt thru' VBA. > > Thanks, > Savan > ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ Live and in personable in the Help Center at PowerPoint Live Sept 21-24, San Diego CA, USA www.pptlive.com |
|
|||
|
Re: guides in ppt file - VBA
Yes you are right, loading the HTML (script editor) takes time. To make it
work other way round, I am deleting all the slides from the source ppt at first. This will make the source ppt light and then HTMLproject loads fast. Then I close it without saving. This works for me. Thanks for your valuable inputs, Regards, Savan "Steve Rindsberg" <abuse@localhost.com> wrote in message news:VA.000041d5.0666da14@localhost.com... > In article <e$Wa4om7IHA.1468@TK2MSFTNGP05.phx.gbl>, Shyam Pillai wrote: >> When you use the HTMLProject object, you are using the Script editor >> which >> needs to be loaded and the time is directly proportional to the number of >> slide in the project. > > As an alternative, save to HTML, work with the saved files, open the HTML > back > into PPT. > > This may or may not be faster, but a quick manual save then re-open (as > HTML) > of the 80-slide presentation would give some idea of the speed difference. > >> >> Regards, >> Shyam Pillai >> >> Image Importer Wizard >> http://skp.mvps.org/iiw.htm >> >> "Savan Gandhi" <savan_gandhi@persistent.co.in> wrote in message >> news:eH4FMfl7IHA.1420@TK2MSFTNGP06.phx.gbl... >> Thanks for your help. One more question is: >> when I try to access "pres.xml" file from HTMLProject (presentation >> property) it takes around 80 sec for a ppt file of 100 slides. Do we have >> other alternative from performance perspective? >> >> sourcePres.HTMLProject.HTMLProjectItems.Item("pres .xml").Text // this is >> taking 80 sec for 100 slide ppt >> >> Thanks, >> Savan >> "Savan Gandhi" <savan_gandhi@persistent.co.in> wrote in message >> news:ekshAOL7IHA.1592@TK2MSFTNGP04.phx.gbl... >> Hi, >> I want to know where in ppt, the guides are stored. They are accessible >> from >> View > Grid and Guides > Display drawing guides on screen. I think they >> are >> ppt specific and not powerpoint specific. I need where they are stored as >> I >> need to copy that information from source ppt to destination ppt thru' >> VBA. >> >> Thanks, >> Savan >> > > ----------------------------------------- > Steve Rindsberg, PPT MVP > PPT FAQ: www.pptfaq.com > PPTools: www.pptools.com > ================================================ > Live and in personable in the Help Center at PowerPoint Live > Sept 21-24, San Diego CA, USA > www.pptlive.com > |
![]() |
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|