How to fix table name by vba

  • Thread starter Thread starter kelly
  • Start date Start date
K

kelly

Hi, i got one problem with table in powerpoint recently.
there are lots of tables should be dealed with in a powerpoint. so i
wrote some macro.
step one: name each table as "Table"
step two: copy data from excel to powerpoint
step three: update format of each table

But when i finished copy& paste data from excel to powerpoint. The
name of the table changed from "Table" to "Group****". I suspected it
is due to the format of the table is adjusted itself when running
syntax at step2.

So when the syntax can not run at step3. Is there any solution to fix
the name of table??
 
Kelly said:
Hi, i got one problem with table in powerpoint recently.
there are lots of tables should be dealed with in a powerpoint. so i
wrote some macro.
step one: name each table as "Table"
step two: copy data from excel to powerpoint
step three: update format of each table

But when i finished copy& paste data from excel to powerpoint. The
name of the table changed from "Table" to "Group****". I suspected it
is due to the format of the table is adjusted itself when running
syntax at step2.

So when the syntax can not run at step3. Is there any solution to fix
the name of table??
Click to expand...

Store the name in a temporary variable before running the code that changes the
name; then set the name back to the value of the temporary variable after.
That might do it.

More generally, use tags instead of names.

Working with Tags (and a bit about Functions)
http://www.pptfaq.com/FAQ00815.htm
 
Back
Top