Try this. Fox does not support the word argument so you must find the Number value. Some times easy, some time not.
Fexcel.cells[3,3].HorizontalAlignment =7
or
Fexcel.range("B3").horizontalalign=7
HTH
Jeff
>I have an application in vfp, and I'm using excel for make some reports, my reports need use excel functions, and i have not problem with this, but i can not center an cell in the worksheet with the command
>Fexcel.range("B3").horizontalalign="xlcenter"
>this give me a error
>i tray to do this
>Fexcel.cells(3,2).horizontalalign="xlcenter"
> and i can not center my information
>
>how can i do this?
> sorry for my English
>
>Spanish version:
>
>Tengo una aplicacion, que necesita realizar calculos en excel, y luego enviar a imprimir esta informacion, estoy usando el print y el preview de excel porque siento que funcionan mejor que los de VFP, sin embargo, no logro centrar una celda determinada en en mi hoja de excel porque obtengo un error, yo uso los comandos siguientes:
>
>Fexcel.range("B3").horizontalalign="xlcenter"
>este comando y el siguiente me dan error
>Fexcel.cells(3,2).horizontalalign="xlcenter"
>
>que puedo hacer?
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com