>I need to hide the zero values on an Excel file that I'm creating from VFP. I cannot find a reference to this property in the excellent book "Office Automation". I have also opened the VB macro editor for Excel on files where I am changing the view setting for zeros but I don't see any property listed in the VB macro editor that seems linked to showing the zeros. In Excel 97 I can hide them manually by going to \Options\View\Zero Values and unchecking the Zero Values box. I am thinking it might be a workbook property.
>
>TIA.
oExcel.ActiveWindow.DisplayZeros = .f.
Cetin