C
christophercbrewster via OfficeKB.com
A group of my routines have been working fine and I've made few or no changes
to them recently, but they stopped working. Changes to other routines may
have affected them, but I can't find any direct connection. But they are
affected by two mysterious factors, described below.
Summary of the routines:
- InsertRef lets the user select a tag from a Powerpoint file and creates a
DocVariable with the same name, then inserts a docvariable field in the Word
document.
- UpdateRefs gets the latest slide numbers for the tags, and assigns them to
the matching DocVariables, then refreshes the text.
- The two routines above call CreateTagTable, which opens the Ppt file and
grabs a table previously created in a Ppt slide Notes page (then does other
things with it).
InsertRef and Update Refs started failing today because they couldn't get the
table from Ppt. In debugging, I found two factors: the routines are affected
by (1) the use of a message box that I added to show the string variable that
had just been loaded with the table content in Ppt, and (2) whether the
Powerpoint application object is visible. The Ppt object did not need to be
visible before today. Here's how they're affected:
visible, msg: Both routines work
not visible, msg: Neither routine works
visible, no msg: InsertRef works, UpdateRefs fails
not visible, no msg: Neither works
What's consistent is that "Visible" is necessary (but why?), but the presence
of the message affects the two routines differently. (I'm starting to suspect
an evil spirit.)
I can supply more details. I can send the code if anyone here would look at
it. This is Office 2003 on Windows XP.
to them recently, but they stopped working. Changes to other routines may
have affected them, but I can't find any direct connection. But they are
affected by two mysterious factors, described below.
Summary of the routines:
- InsertRef lets the user select a tag from a Powerpoint file and creates a
DocVariable with the same name, then inserts a docvariable field in the Word
document.
- UpdateRefs gets the latest slide numbers for the tags, and assigns them to
the matching DocVariables, then refreshes the text.
- The two routines above call CreateTagTable, which opens the Ppt file and
grabs a table previously created in a Ppt slide Notes page (then does other
things with it).
InsertRef and Update Refs started failing today because they couldn't get the
table from Ppt. In debugging, I found two factors: the routines are affected
by (1) the use of a message box that I added to show the string variable that
had just been loaded with the table content in Ppt, and (2) whether the
Powerpoint application object is visible. The Ppt object did not need to be
visible before today. Here's how they're affected:
visible, msg: Both routines work
not visible, msg: Neither routine works
visible, no msg: InsertRef works, UpdateRefs fails
not visible, no msg: Neither works
What's consistent is that "Visible" is necessary (but why?), but the presence
of the message affects the two routines differently. (I'm starting to suspect
an evil spirit.)
I can supply more details. I can send the code if anyone here would look at
it. This is Office 2003 on Windows XP.