white_flag
12-19-2011, 06:39 AM
Hello
I try to setup an page from excel to word but I received the following error:
"object doesn't support this property or method"
search on net and seams that .CentimetersToPoints need to be WordDoc.CentimetersToPoints
With WordDoc.PageSetup
.TopMargin = WordDoc.CentimetersToPoints(4.5)
.BottomMargin = WordDoc.CentimetersToPoints(3.7)
.LeftMargin = WordDoc.CentimetersToPoints(2.5)
.RightMargin = WordDoc.CentimetersToPoints(1#)
.Gutter = WordDoc.CentimetersToPoints(0)
.HeaderDistance = WordDoc.CentimetersToPoints(1.25)
.FooterDistance = WordDoc.CentimetersToPoints(0.39)
.PageWidth = WordDoc.CentimetersToPoints(21)
.PageHeight = WordDoc.CentimetersToPoints(29.7)
End With
I putted like this (WordDoc.CentimetersToPoints) but the same error. the rest of the code is going. only this part is not ok. what it is wrong?
I try to setup an page from excel to word but I received the following error:
"object doesn't support this property or method"
search on net and seams that .CentimetersToPoints need to be WordDoc.CentimetersToPoints
With WordDoc.PageSetup
.TopMargin = WordDoc.CentimetersToPoints(4.5)
.BottomMargin = WordDoc.CentimetersToPoints(3.7)
.LeftMargin = WordDoc.CentimetersToPoints(2.5)
.RightMargin = WordDoc.CentimetersToPoints(1#)
.Gutter = WordDoc.CentimetersToPoints(0)
.HeaderDistance = WordDoc.CentimetersToPoints(1.25)
.FooterDistance = WordDoc.CentimetersToPoints(0.39)
.PageWidth = WordDoc.CentimetersToPoints(21)
.PageHeight = WordDoc.CentimetersToPoints(29.7)
End With
I putted like this (WordDoc.CentimetersToPoints) but the same error. the rest of the code is going. only this part is not ok. what it is wrong?