Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Auto excel borders
Message
From
23/02/2013 08:41:44
 
 
To
22/02/2013 23:10:02
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01566801
Message ID:
01566808
Views:
69
>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