>I'm trying to format some cells from vfp, and commands like
>
>oExcel.Selection.HorizontalAlignment = xlCenter
>
>to center a cell, which the excel macro gives, don't work from vfp, since xlCenter is some kind of "local" var, I guess. I'm not finding anything in the VBA help, either. Anyone done this or know where to find a list of the formatting values?
In Fox - you need to use a number to specify the alignment. For example:
xl.cells(nline,1).SELECT
xl.SELECTION.horizontalalignment = 4
I believe (if memory serves me right) that 4 is right alignment.
Jeff Pearce