Using Excel with Fivewin and OLE

Using Excel with Fivewin and OLE

Postby byron.hopp » Sat Feb 10, 2024 1: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
byron.hopp
 
Posts: 382
Joined: Sun Nov 06, 2005 3:55 pm
Location: Southern California, USA

Re: Using Excel with Fivewin and OLE

Postby Antonio Linares » Sat Feb 10, 2024 6:12 am

Dear Byron,

Maybe this way ?

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

just guessing...
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42099
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Re: Using Excel with Fivewin and OLE

Postby byron.hopp » Sat Feb 10, 2024 6:15 am

You are correct, seems to easy, thank you.
Thanks,
Byron Hopp
Matrix Computer Services
byron.hopp
 
Posts: 382
Joined: Sun Nov 06, 2005 3:55 pm
Location: Southern California, USA


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 79 guests