Go Back   { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > MS Office > PowerPoint

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-23-2008, 11:02 AM
Savan Gandhi
 
Posts: n/a
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
Reply With Quote
  #2 (permalink)  
Old 07-23-2008, 02:55 PM
Steve Rindsberg
 
Posts: n/a
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

Reply With Quote
  #3 (permalink)  
Old 07-23-2008, 05:10 PM
Shyam Pillai
 
Posts: n/a
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

Reply With Quote
  #4 (permalink)  
Old 07-25-2008, 06:09 AM
Savan Gandhi
 
Posts: n/a
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
>



Reply With Quote
  #5 (permalink)  
Old 07-25-2008, 06:10 AM
Savan Gandhi
 
Posts: n/a
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



Reply With Quote
  #6 (permalink)  
Old 07-25-2008, 08:51 AM
Savan Gandhi
 
Posts: n/a
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

>
>



Reply With Quote
  #7 (permalink)  
Old 07-25-2008, 01:11 PM
Savan Gandhi
 
Posts: n/a
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
Reply With Quote
  #8 (permalink)  
Old 07-25-2008, 03:22 PM
Shyam Pillai
 
Posts: n/a
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

Reply With Quote
  #9 (permalink)  
Old 07-25-2008, 06:57 PM
Steve Rindsberg
 
Posts: n/a
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

Reply With Quote
  #10 (permalink)  
Old 07-28-2008, 11:01 AM
Savan Gandhi
 
Posts: n/a
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
>



Reply With Quote
Reply

  { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > MS Office > PowerPoint


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 06:18 AM.


Powered by vBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc.
© 1999-2008 mindfrost82.com v11.0


Sponsors:
Daddy Yankee | Loans | Consolidation | Anime | Debt Management



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109