Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Auto excel borders
Message
From
24/02/2013 02:41:23
 
 
To
23/02/2013 08:41:44
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01566801
Message ID:
01566818
Views:
94
problem with the solution Tamar is that this creates a box around each cell instead of the defined area.
oXL.Range("a1:d1").Borders.Linestyle = 1
>>Does anyone know how to place a border around a group of cells in excel automation.
>>so far so good.
>>thanks
>>k
>>
>>oRange = oWorkbook.Sheets[1].range("A1", "B2") 
>>oRange.Interior.ColorIndex = 41
>>oRange.Font.Name= "corbel"
>>oRange.Font.Size= 11 
>>oRange.Font.Italic = .T.
>>oRange.Font.Bold = .T.
>>oRange.font.ColorIndex = 19
>>
>
>Check out the Borders collection. Here's the Help for the 2007 version, but it shouldn't be terribly different, whatever version you're using: http://msdn.microsoft.com/en-us/library/office/bb210096%28v=office.12%29.aspx
>
>Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform