Information générale
Catégorie:
COM/DCOM et OLE Automation
.Columns("A:A").NumberFormat = "0;-0;;@"
>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement