Alignement in Excel (solved)

[driessen]

Hello,

I want to make an Excel-document from my FWH-application.

I need to align the cells in my Excel document.

To achieve tha, I try this :

Code: Select all  Expand view

/* Explanation cPos :
   cPos = 0 -> Standaad alignement
   cPos = 1 -> Left alignement
   cPos = 2 -> Centered
   cPos = 3 -> Right alignement
   cPos = 4 -> Left + right alignement
*/
oSheet:Range("A1"):HorizontalAlignment := cPos

Unfortunately, nothing is changing.

What do I do wrong?
Does anyone have another suggestion?

Thanks a lot in advance for any help.

[cnavarro]

Not valid this?
viewtopic.php?f=3&t=32228&p=188814&hilit=HorizontalAlignment#p188814

[driessen]

Thanks a lot for your help. It works just fine.

Sorry I couldn't remember my previous topic about this subject.