I need to set the horizontal alignment in a range of cells in a worksheet, I’m using C++Builder 11 and the Office2K component.

the code:

(ExWs->Columns->get_Range(TVariant("G1"), TVariant("G2000")))->set_HorizontalAlignment(TVariant(DT_CENTER));

has no effect.

In some posts over internet they suggested to use xlCenter instead of DT_CENTER but I get the error Undefined symbol xlCenter

I think this is a trivial question but it is really hard to find some information/guide/help about this C++Builder component, I hope someone can help me.

Thanks