Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OLE to Excel
Message
From
30/09/1998 17:35:36
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
OLE to Excel
Miscellaneous
Thread ID:
00142588
Message ID:
00142588
Views:
53
I am using VFP 5 to control Excel. I have been
attempting to use the Macro recorder to provide
some help, but now I am stuck.

All I want to do is select a portion of a row
(say B3:B10) and add a continious line to the top
edge of this selected area.

The code from Excel returned the following:

Range("B3:B10").Select
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous && value of a 1
.Width = xlThin && value of a 2
.ColorIndex = xlAutomatic && value of -4105
EndWith

What is the value of xlEdgeTop? Not sure this syntax
will port to VFP. anyone know how to draw a solid
line through a selected area in Excel using VFP?
Next
Reply
Map
View

Click here to load this message in the networking platform