An interesting attempt. Turning the tedious directory work in Excel & Word into Access GUI.<\/p>\n
Cool trick<\/a>: Round-up \/ Ceiling of a positive double: It would appear that some MS Word pages do not follow the same line number limit as the rest of the pages. There's a math<\/a> (or here<\/a>) to make it work: There was a problem in my code:<\/p>\n I keep getting Run-time error '462': So far so good, if the spacing calculation for getting every page to start with a new contact is still a problem, then perhaps it's better to program a page break into it.<\/p>\n","protected":false},"excerpt":{"rendered":" An interesting attempt. Turning the tedious directory work in Excel & Word into Access GUI. Cool trick: Round-up \/ Ceiling of a positive double: In VB.NET, using the fact that int() = floor() -Int(-a\/b) It would appear that some MS … Continue reading
\nIn VB.NET, using the fact that int() = floor()
\n-Int(-a\/b)<\/p>\n
\nWord uses points. 72 points = 1 inch. Single line spacing is 120% of font size. This may be kind of tricky (footer\/header margins are not accounted for in the article, which I think they should). For some reason the margins left about 9.3\" of writing space per page, taking away 1.6\" which I have no clue how it came about. Or I may pursue a different approach programmatically.<\/p>\n
\nThe remote server machine does not exist or is unavailable. Debug targets
\nObjWord.Selection .Paragraphs.TabStops
\n.Add Position:=InchesToPoints(1.5), Alignment:=wdAlignTabLeft
\nSolution<\/a>: ObjWord.InchesToPoints(1.5)<\/p>\n