Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
OLE to Excel
Message
De
30/09/1998 17:35:36
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
OLE to Excel
Divers
Thread ID:
00142588
Message ID:
00142588
Vues:
54
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
Fil
Voir

Click here to load this message in the networking platform