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 -