How to change the Position type in a ORG Chart through a macro

T

Tshelar

Hi Guys,
I have written a macro that imports data from a access database and creates
a Org Chart.
I want to change certain Positions depending on the text it contains to
Vacancy. How does one achieve this?

Thanks
Tushar
 
J

JuneTheSecond

objShape.Cells("TxtPinX").Formula = "Width*1.0"
would change x position of text to Width*1.0 of the shape.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summarised Org Chart at certain level 0
VBA word change keys 0
Need VBA Macro to Loop through pages and print counter in footer of each page 9
Visio 2003 Org Chart Wizard 1
Org chart shape sizes 0
Resizing the Shape when the text does not fit in. 1
Need to change part of the text to bold in a Position (Shape) 2
Changing position type in Visio org chart 0

Top