Sorting in Excel-object in PP or start an internal macro in thatobject from PP

[Rene]

Hi all,

I have made a PP macro that moves info to an
Excel-object on one of my slide. Now I would like to
sort that information in that object. Is there anyone
who knows how? I tried copying the Excel macro into my
PP macro but it does noet work.
Or is the a way to start a sorting macro embedded in
the Excel-object from within a PP macro?

I am programming this for an amateur soccerclub that
wants to show the weekly standings on tv with the
presentation.

Thanks in advance.. Rene van Kwawegen

 

[Steve Rindsberg]

Hi all,

I have made a PP macro that moves info to an
Excel-object on one of my slide. Now I would like to
sort that information in that object. Is there anyone
who knows how? I tried copying the Excel macro into my
PP macro but it does noet work.
Or is the a way to start a sorting macro embedded in
the Excel-object from within a PP macro?

Generally, it's possible to automate any of the Office programs from any other
Office program. Have a look at the entries here for examples:

Automating one app from another
http://www.rdpslides.com/pptfaq/index.html#Automating_one_app_from_another

 

[Rene]

Steve,

Thx I did it. My macro now edits results from within an
excelobject on slide a and fills cells in an
excelobject on slide b. after this first part, the
macro copies e group of cells to another position and
then sorts them. I made a mistake with the variables in
the sortmethod.

If anyone is interested in my result he/she can send me
an email and i will send the presentations with the code...

Greets, Rene


Steve Rindsberg schreef:

 

[Steve Rindsberg]

Thx I did it.

Glad to hear it. I'm guessing it only took a few add'l lines of code, too.
Neat, isn't it?

My macro now edits results from within an

 

[Rene]

Hi Steve,

Yes it is really great to ee things work. Specially
because you know it has t owork when you write it down..

Nice to have a conversation with someone who knows his
stuff. I am educated in using vba for technical
solutions and it is affording to develop a routine for
an amateur sportsclub or so...

Greets, Rene


Steve Rindsberg schreef: