View Single Post
  #12   Report Post  
Hari Prasadh
 
Posts: n/a
Default

Hi Jon,

Its fantabulous.

I tried it on one slide and it works flawlessly and no objects get
dislocated and neither repositioned . Moreover my code also becomes less
cluttered as now I wont have to remember object positions and what not . In
the old way of copy-paste even after remembering and forcibly applying the
positions the stuff was far from perfect and considerable manual formatting
was required.

Just to tell you in the old method I was also having problems of view of the
charts changing from charts to the worksheet behind the data, which caused
further aggravation for me.

Im surprised that this simple solution wasnt thought by before!!! (Brian,
cant resists from pulling your legs - I can hide under the cloak of being a
beginner but what about you!!)

This technique worked well enough that I might even have to start using it.
Hear that, Brian?


2 points I would like to add: -

a) In one of the earlier posts in PPT group I asked for project mgmt of PPT
automation using Excel and Brian asked a very important question as to the
base application (excel or PPT) im using for programming. I said excel
because I could pinch Jon's pre-built tutorials. I think one more important
needs to be added to the list which is as to whether one is creating objects
on the fly in PPT or whether one has a template in which one is populating
new data using Jon's latest method. The second would be extremely helpful
when the slides involve lot of custom/individual formatting differences
across objects (within slides/across slides). I think that way the if one
has a pre-built template the one doesnt have to "code" those custom
formatting within each individual sub. Less code, less debugging headache.

b) Jon if possible please add this new way of your to the web-site. Others
wont have to break their heads with PPT object dislocations.

Regards,
Hari
India