Question for Shyam Pillai

  • Thread starter Thread starter Edward
  • Start date Start date
E

Edward

Hi shyam ,
I have used your split table code in your website( I have used youre website
a lot so I really appreciate yoru contribution to VBA community ), there are
two problems that I thought you might help first after we split the table
second table doesn't keep the correct row height size although the font sizes
are correct and also it doesnt allow to resize it manually or even with
VBA code ! socond is the fact that we ca't insert a table larger than 25 rows
in PP even if we use VBA so if we have a large table thsi code will fail ,
although I know how to solve thsi problem. I was thinking to create several
slides and copy my 200 rows tables to several slides and then loop through
your code and then delete those extra slides ( I think it will work but it
will be a great headache to go through all these extra steps). I was reading
about tables in PP2007 and I was glad to see they have changed the entire
tabel concets in PP and now they are much more powerful and now we can
easily bring tables from excel to PP , which is great !!
 
Thanks Steve. your code works great but there is a problem that I can't
figure out how to solve it. it seems reasonable that following code must work

newShape.Table.Rows(i).Height =OriginalShape.Table.Rows(i).Height

but it can't change the row height of newly added rows , font sizes that I
copy from the original table to the secodn table are correct but row heights
are much bigger ,
I can reduce them to a certain size if i reduce MarginBottom of each
textframe but still they are not correct. It seems something prevents to
reduce the size of each row ( I can't do it even manually ,it goes back to
its original state) do you know what objects or properties I should work
with?
 
Allr right , I made a small change in Shyam's code and it seems to work now
instead of copying ...TextFrame.TextRange.Copy I copy paragraphs
.... TextFrame.TextRange.Paragraphs().Copy now when I apply the height from
original table it changes the height :)
I don't know what will be the implications of this change in different
situations ( like if we have a picture in table insetad of text ,...) but at
least now I can make it work for some cases.
Alos I can use your suggestion to deal withh tables larger than 25 rows.
Thanks a lot :)
 
Back
Top