Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
First time with VFP to Excel
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00643532
Message ID:
00643681
Vues:
21
This message has been marked as the solution to the initial question of the thread.
>* Problems start here:
>* VFP Doesn´t recognize xlCenter, xlBottom, xlCenter, etc., suposedly
>* Added with #Include.
> .HorizontalAlignment = xlCenter
> .VerticalAlignment = xlBottom
What happens if, instead of using constants, you indicate the value of the constants? Does the problem go away?


> " De " + ALLTRIM(STR(RECCOUNT()))
Tip: You can use: transform( reccount() ) and that will trim spaces as well.


>*Can´t use this, says "Expression is not valida outside With/endwith
>*I can´t use .cells even with some diferent ways of with-endwith
> .Cells(lnFila,1).VALUE = SALIDA.tdia
> .Cells(lnFila,2).VALUE = SALIDA.tinternet
I think the current WITH at this point is WITH loExcel. I don't think Cells belong to Excel object. You might need to wrap these calls with the appropriate WITH, for example WITH .Sheets(1)
Hector Correa
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform