ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Organization Diagrams in Excel 2003 (https://www.excelbanter.com/excel-programming/331554-organization-diagrams-excel-2003-a.html)

DigiWongaDude

Organization Diagrams in Excel 2003
 
I am pulling my hair out trying to find a way to work with the new
organization diagram through VBA in Excel.

For instance, just trying to update the text in a node, any node for that
matter is proving very difficult indeed. The samples I've tried either dont
apply specifically to the organization chart diagram (they might only be
appropriate to a pryamid diagram for example), and, to matters even worse...
the methods and collections seem to differ for org charts depending on
whether im using word or excel.

For example, in excel the text property belongs to the Characters
Collection, whilst in Word, the text property belongs to the TextRange
collection.

With








DigiWongaDude

Organization Diagrams in Excel 2003
 
I stopped short in the last post...

With Regards

Digi (lol)






All times are GMT +1. The time now is 11:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com