Using Excel with Fivewin and OLE

Post Reply
byron.hopp
Posts: 388
Joined: Sun Nov 06, 2005 3:55 pm
Location: Southern California, USA
Contact:

Using Excel with Fivewin and OLE

Post by byron.hopp »

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,
Thanks,
Byron Hopp
Matrix Computer Services
User avatar
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

Post by Antonio Linares »

Dear Byron,

Maybe this way ?

Selection:FormatConditions:Add( xlCellValue, xlEqual, .T. )

just guessing...
regards, saludos

Antonio Linares
www.fivetechsoft.com
byron.hopp
Posts: 388
Joined: Sun Nov 06, 2005 3:55 pm
Location: Southern California, USA
Contact:

Re: Using Excel with Fivewin and OLE

Post by byron.hopp »

You are correct, seems to easy, thank you.
Thanks,
Byron Hopp
Matrix Computer Services
Post Reply