Visio Reports - Text Justification

[th0rh]

Not sure if this is the correct forum section to post to ... 

I can get a report to work, no problem - but I would like to change the text justification in the report from right to left.  How can this be done?   

Thanks to all in advance.

[Paul Herber]

Which report and what type of diagram?

[th0rh]

Process Engineering / Process Flow diagrams - Equipment List.

Thanks

[Paul Herber]

Which report format?

[th0rh]

Excel embedded in Visio sheet.

Thanks

[Visio Guy]

If its an Excel object embedded in Visio, then you should be able to double-click it to activate in-place Excel editing. Then you can use Excel's alignment functions to modify columns.

[th0rh]

Yes, I understand that an embedded Excel sheet can be modified - but these changes don't "stick" (ie. when the list is updated, it always reverts to the original formatting, and I have to go back reformat the column justifications). 

I know nothing about the XML programming that drives the interface between Visio and Excel...but my guess is that it must be possible to modify the schema to permit the desired column justifications.     Does anyone know how to do this?  Am I even on the right track?

[Yacine]

The truth is, that the visio reports are in matters of formating a pain in the proverbial.
There isn't any documentation anywhere and no format templates to be found.
We opted for a self written vba routine to get the results we wanted.

Code Select Expand

   Dim xlsSheet As Excel.Worksheet
   
   Set xlsShp = Application.ActiveWindow.Page.InsertObject("excel.sheet", visInsertAsEmbed)    
   Set xlsSheet = xlsShp.Object.Worksheets(1)

   For Each shp In ActiveWindow.Page.Shapes
...
   Next shp
...