Hi tinfanide,
This issue is that, when using late binding, the calling app has no access to the called app's object model until the code is compiled. In this case, Excel has no way of knowing what wdBorderTop or wdLineStyleSingle, for example, are.
FWIW, if you'd prefer to leave the parameters unchanged, you could declare them beforehand with code like:
Const wdBorderTop As Long = -1
Const wdLineStyleSingle As Long = 1
This has the advantage that expressions like:
.Borders(wdBorderTop).LineStyle = wdLineStyleSingle
are much easier to interpret than:
.Borders(-1).LineStyle = 1
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|