Hello!
It is possible that it already exits a similar post, but I haven't found it. Well, my problem is that I don't know how to modify the number of columns (or rows) in the Excel object I have inserted. I mean, when I insert the table, it have visible 10 rows and 7 columns. How can modify this? Modifying the size in the shapesheet only modify the size, but the number of rows and columns remains constant.
Thanks!
First double click the excel object or right click - Worksheet Object - Edit , then resize the object by pulling edges
But I want to do that process by code. Is there any way?
I think it is not possible to do it programmatically. Please check the similar question and answer in the link below
https://social.msdn.microsoft.com/Forums/office/en-US/c27064ac-97d3-4d35-9f56-ce626b1fd8b5/resize-an-embedded-excel-ole-object-in-word-programattically?forum=worddev (https://social.msdn.microsoft.com/Forums/office/en-US/c27064ac-97d3-4d35-9f56-ce626b1fd8b5/resize-an-embedded-excel-ole-object-in-word-programattically?forum=worddev)
http://visguy.com/vgforum/index.php?topic=410.0
Then, I can't do it using vb :'(
Thanks!