FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Using Excel with Fivewin and OLE
Posts: 408
Joined: Sun Nov 06, 2005 03:55 PM

Using Excel with Fivewin and OLE

Posted: Sat Feb 10, 2024 01:04 AM

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
Posts: 44162
Joined: Thu Oct 06, 2005 05:47 PM

Re: Using Excel with Fivewin and OLE

Posted: Sat Feb 10, 2024 06:12 AM

Dear Byron,

Maybe this way ?

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

just guessing...

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 408
Joined: Sun Nov 06, 2005 03:55 PM

Re: Using Excel with Fivewin and OLE

Posted: Sat Feb 10, 2024 06:15 AM

You are correct, seems to easy, thank you.

Thanks,

Byron Hopp

Matrix Computer Services

Continue the discussion