How to Change an Excel Object

Started by davidgon, February 22, 2017, 01:41:38 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

davidgon

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!


metuemre

First double click the excel object or right click - Worksheet Object - Edit , then resize the object by pulling edges

davidgon

But I want to do that process by code. Is there any way?



davidgon

Then, I can't do it using vb  :'(

Thanks!