Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Vfp and Excel
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00770967
Message ID:
00770994
Vues:
18
This works for me:

ObjExcel= CREATEOBJECT("Excel.Application")
ObjExcel.Workbooks.OPen(somefile)
ObjExcel.ActiveSheet.Range("B34:B300").Select
....


>Yuris thanks very much! For some reason in the following, the last range select
>selects a13:m229, the full used range of the spreadsheet, but row 13
>and below. How can I get it to select only b13:b229??
>STeve
> With o.Application
> .Range("B13").Select
> .ActiveCell.FormulaR1C1 = "=MID(RC[-1],1,10)"
> .Range("B13").Select
> .Selection.Copy
> .Range("A1").Select
>wait
> .Range("B13:B229").Select && the last range select
> EndWith
>wait
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform