Information générale
Catégorie:
Codage, syntaxe et commandes
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?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement