Quote:
Originally Posted by macropod
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
|
Yes, ya're right. Instead of setting Const variables everytime, I'd rather remember the numeric values which I've just found not too hard to memorise, clockwise (-1,-2,-3,-4) for wdBorderType, for example.