Value of vertical alignment constants for Excel 97
There are times when good old Microsoft leaves me tearing my hair out. This
is one of those occasions where I've spent hours over a few lines of code
for want of a bit of clearly presented documentation. A concept that is
alien to Bill and his chums in Redmond...
I'm using automation to manipulate an Excel 97 workbook from Access 97.
It's all working OK, except that I'm having problems with expressions that
would normally use Excel constants, such as
With Selection
.VerticalAlignment = xlCenter
I've found that Access reports an error if the xlCenter constant is used (or
any other one for that matter). It seems that xlCenter has to be passed as
a numeric value.
I've found a couple of code snippets where someone has obviously managed to
find what Microsoft seem intent on keeping secret...
With .Selection
.HorizontalAlignment = 7 'xlCenterAcrossSelection
.VerticalAlignment = -4107 'xlBottom
Unfortunately, I'm currently looking for the equivalent value of xlCenter,
but the rest would be handy!
Does anyone know where I can find the numeric equivalents for the constants
used by the Excel 97 object model?
I've searched all over the place but, so far, it's been a complete waste of
time.
Many thanks if you can point me in the right direction
Mike