>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
Most are pretty direct, say oSheet is your vfp object reference...
oSheet.Range(etc).Select && works
oSheet.Cutcopymode = 'False' && needs quotes
As for the Excel variables (like xlDown), you should download the Excel.h file from the UT files section to declare as an #INCLUDE file
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.