Information générale
Catégorie:
Codage, syntaxe et commandes
Is there any way I can trap errors when doing OLE automation to EXCEL (any MS products) instead of me getting unfriendly error message? How do I check whether EXCEL is installed in my customer PC so that I can disbale the command button to launch EXCEL.
I would like to highlight rows in the EXCEL with different color based on exceeded value on the row cells. How can I do this or command I can use. I have tried recording the macro and typing the commands but this does not work. The macro recorded is as follows : (how do I translate this in VFP)
.Row('7:7').Select
With Interior.Selection
.ColorIndex=6
.Pattern=lssolid
ENDWITH
Thanks.
Suivant
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