The following line of code is from an Excel recorded macro:
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual,Formula1:="=TRUE"
Seems like the Add method has three parameters, how do you call this in FiveWin?
Thanks,
Using Excel with Fivewin and OLE
-
- Posts: 388
- Joined: Sun Nov 06, 2005 3:55 pm
- Location: Southern California, USA
- Contact:
- Antonio Linares
- Site Admin
- Posts: 42521
- Joined: Thu Oct 06, 2005 5:47 pm
- Location: Spain
- Has thanked: 31 times
- Been thanked: 76 times
- Contact:
Re: Using Excel with Fivewin and OLE
Dear Byron,
Maybe this way ?
Selection:FormatConditions:Add( xlCellValue, xlEqual, .T. )
just guessing...
Maybe this way ?
Selection:FormatConditions:Add( xlCellValue, xlEqual, .T. )
just guessing...
-
- Posts: 388
- Joined: Sun Nov 06, 2005 3:55 pm
- Location: Southern California, USA
- Contact:
Re: Using Excel with Fivewin and OLE
You are correct, seems to easy, thank you.
Thanks,
Byron Hopp
Matrix Computer Services
Byron Hopp
Matrix Computer Services