>Hi All,
>
>I need some help in VFP Excel automation. This is what I have done so far.
>
>•Open excel workbook in VFP
>•Formatted the active sheet the way I want
>
>What I need to do now is ..
>•Replace all “$null” with “0” in a excel sheet with in my VFP program.
>
>I recorded macros in excel and came up with this.
>
>Cells.Replace What:="$null", Replacement:="0", LookAt:=xlPart, _
> SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
> ReplaceFormat:=False
>
>I just don’t know how to apply that within my VFP prg.
>
>Please HELP !!!!
>
>TIA
>
>- Jeana -

There is an EXCEL VBA Help where you can verify the syntax of this command.
This is what one may see (and in some cases the sintax or options may vary in different Excel versions):

expression.Replace(What, Replacement, LookAt, SearchOrder, MatchCase, MatchByte, SearchFormat, ReplaceFormat)

Just go to Excel, hit ALT+F11, then F1 to invoke the VBA Help.