Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Foxpro to Excel
Message
From
28/06/1999 09:58:00
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Foxpro to Excel
Miscellaneous
Thread ID:
00234738
Message ID:
00234738
Views:
58
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
Next
Reply
Map
View

Click here to load this message in the networking platform