Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Craig Moore
  Where is Craig Moore?
 
 United Kingdom
 Craig Moore
 To: Victor DelValle
  Where is Victor DelValle?
 Arecibo
 Puerto Rico
 Victor DelValle
 Tags
Subject: RE: Excell automation
Thread ID: 21826 Message ID: 21827 # Views: 31 # Ratings: 0
Version: Visual FoxPro 7 Category: Microsoft Office Automation
Date: Wednesday, April 02, 2003 5:09:23 PM         
   


.Range("&lnrangel").HorizontalAlignment = -4152 && Right Alignment
.Range("&lnrangel").HorizontalAlignment = -4131 && Left Alignment

hope it helps

Craig


> Hello Experts:
> I'm working with Excell automation and working with the cells format, i can format the font,fontsize, and type but i have'nt been able to set the cells alignment. Can anyone help. Also i will like some information about Automation error handling.
> The code i'm using to format the cells is something like this:
>
> .Range("&lnrangel").font.Name ="Times New Roman"
> .Range("&lnrangel").font.size="8"
> .Range("&lnrangel").font.bold=.T.
>
> Thank you
> Victor Del Valle
> Arecibo, P.R.


COMPLETE THREAD

Excell automation Posted by Victor DelValle @ 4/2/2003 4:26:25 PM
RE: Excell automation Posted by Craig Moore @ 4/2/2003 5:09:23 PM
RE: Excell automation Posted by Victor DelValle @ 4/2/2003 6:42:30 PM