Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Foxpro to Excel
Message
De
28/06/1999 09:58:00
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Foxpro to Excel
Divers
Thread ID:
00234738
Message ID:
00234738
Vues:
60
Everyone on the board is telling me to use the VBA editor to get the syntax when trying to format a excel application thru foxpro. Well here is a bit from a macro I created. How do I word to put this in fox pro code ? thanks



Range("A1").Select
Selection.End(xlToRight).Select
Selection.End(xlDown).Select
Range("K661").Select
ActiveCell.FormulaR1C1 = "=SUM(R[-659]C:R[-2]C)"
Range("K661").Select *****(this moves it two cell down)
Selection.Copy
Range("D661:J661").Select
Range("J661").Activate
ActiveSheet.Paste
Application.CutCopyMode = False
Range("I651").Select
End Sub
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform