guides in ppt file - VBA

[Savan Gandhi]

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

 

[Shyam Pillai]

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

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

 

[Savan Gandhi]

Thanks Steve,
By manipulating HTMLProject property of presentation, I am able to copy the
drawing guides thru' VBA.

Thanks once again,
Regards,
Savan

 

[Savan Gandhi]

Thanks Shyam,
Your code was extremely helpful. I am able to copy the drawing guides by
using HTMLproject property.

Thanks once again,
Regards,
Savan

 

[Savan Gandhi]

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]

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

 

[Shyam Pillai]

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



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

 

[Savan Gandhi]

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

 

[Savan Gandhi]

Thanks Steve. My pleasure.

Brilliant workaround. Thanks for that.


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