Macro for PPT changes the object number when looping over 42 times.

W

Wesslan

Hi,

I have an issue with a macro which creates automatic slides for me in
PPT. The data is taken from excel and then put in the corresponding
place (object) in PPT. However, after having looped exactly 42 times,
the object which is being pasted to (I have one file which is the
source file that is opened and manipulated with the data over and
over
again and saved everytime depending on the analysed firms name)
changes number from 292 to 293, and if I click it again it changes to
294 etc... So for the first 42 times the object continues to be
"group
292" but on the 43 rd time, it becomes "group 293", any suggestions
as
to why this is and how to solve it? I am thinking maybe I need to
create a templatefile instead of a normal PPT presentation file used
as template?


The code used is:

Rectangle = "Group 292"

oPPTApp.ActiveWindow.Selection.SlideRange.Shapes(Rectangle).Select


Best regards,


Peder
 
C

Chip Pearson

I would give the objects in PPT real names, not the default names. In PPT
2003 and earlier (not sure about PPT 2007), the UI doesn't give you a method
to name an object. See
http://www.cpearson.com/PowerPoint/SlideAndShapeRenamer.htm for a PPT COM
Add-In that allows you to name slides and objects on slides.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
W

Wesslan

Chip,

I had a problem with installing the COM Add-In. I managed to find it
in the Com Add-In as you describe in the helpfile under the "add"
section and browsed for it. Both the helpfile and the .dll file are in
the same catalog, but once I have pressed "Add" it doesn't show up
under the "Add-Ins available". I am using the 2003 office, is this
something you have had others experience before?

If you have some help or the original code, I would truly appreciate
it.

Sincerly,

Peder
 
C

Chip Pearson

I'm not sure why it isn't listed. (You are sure, aren't you, that you're
looking under *COM* Add-Ins, not normal PPT add-ins?). I just loaded it up
into PPT 2003 under Vista and it works fine.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time entry macro (entering times via the keypad) 2
HELP! Macro FAILS when I copy the worksheet... 4
Outlook macro - MAPIFolder looping extremely slow 0
Summing with Macro 3
sslStream.Read() returns invalid data when socket times out from block/nonblock IO? 0
Slow Startup When Away From Domain After GP Software Install 3
Abykus - An object-oriented spreadsheet for Windows 2
powerpoint tips 1 2

Top