1 - I'm sure it's possible
2 - Simple - just add script in the Actions-section of the shape's shapesheet (it will appear in the right-click menu), which can trigger anything you've written in VBA
3 - I guess you're just gonna 'send' a collection, right? -But what exactly do you mean by Sending...
To be more exact:
When I move my VISIO-drawings between different computers, the layout of text in some shapes changes - for example, a shape where I have calculated the width of the shape to depend on the width of the text gets the wrong width, and displays the text on two rows instead of one...
I haven't had any problems with this
It's probably a good idea to ignore Wizards as soon as you want any Real control over things :)
Get the excel-document with GetObject, or something
Get the desired sheet
set the values of cells by:
sheet.cells(x,y)="MyData"
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.