Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Camil Ghircoias
  Where is Camil Ghircoias?
 Sibiu
 Romania
 Camil Ghircoias
 To: Khurram Tahir
  Where is Khurram Tahir?
 Karachi
 Pakistan
 Khurram Tahir
 Tags
Subject: RE: Setting Cell Borders through automation
Thread ID: 228307 Message ID: 228315 # Views: 1 # Ratings: 1
Version: Visual FoxPro 9 Category: Microsoft Office Automation
Date: Monday, May 18, 2009 9:50:05 AM         
   


* get into a variable the xls range object
mXlsRange=XLSHEET.RANGE(xlsheet.cells(m.mRow-m.mTop,m.mLeftCol),xlsheet.cells(m.mRow+m.mBottom,m.mRightCol))

m.mXlsRange.Borders.LineStyle=1 &&complete border 1=normal,2=dotted
m.mXlsRange.Borders(1).LineStyle=1 && left border 1=normal,2=dotted
m.mXlsRange.Borders(2).LineStyle=1 && right border 1=normal,2=dotted
m.mXlsRange.Borders(3).LineStyle=1 && top border 1=normal,2=dotted
m.mXlsRange.Borders(4).LineStyle=1 && bottom border 1=normal,2=dotted

Camil

ENTIRE THREAD

Setting Cell Borders through automation Posted by Khurram Tahir @ 5/18/2009 8:39:34 AM
RE: Setting Cell Borders through automation Posted by JaiPrakash Bhandari @ 5/18/2009 9:21:41 AM
RE: Setting Cell Borders through automation Posted by Camil Ghircoias @ 5/18/2009 9:50:05 AM
RE: Setting Cell Borders through automation Posted by Khurram Tahir @ 5/19/2009 7:57:20 AM