Size to fit drawing

[alanrenouf]

Is there a way to program the paper to use 'Size to fit drawing' as you would do within visio ?

Thanks

[Paul Herber]

You need to get the reference to the page then in the PageProperties section set the DrawingSizeType cell to visTight.
I don't do enough VBA etc to get the syntax exact but .

Code Select Expand


  page.cellSRC[visSectionObject, visRowPage, visPageDrawSizeType] := visTight;

is what it looks like in Delphi (no, I haven't checked it!).