Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Boolean in VBA are returned in local language
Hi,
My VBA script reads some values from cells and sends them to a webservice. I just realized that using a German Excel e.g. cell.Font.Strikethrough is returned as Wahr/Falsch instead of True/False. I tried following code snippet I found online but unfortunately didn't help either: ...... Dim bolVal As Variant bolVal = cell.Font.Strkethrough If CStr(bolVal ) = "False" Then ' Unfortunately this didn't help. ........ Has anybody an idea how to convert this from any language to True/False? Reto |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Boolean in VBA are returned in local language
If Not CStr(bolVal) then
-- Cheers Nigel wrote in message oups.com... Hi, My VBA script reads some values from cells and sends them to a webservice. I just realized that using a German Excel e.g. cell.Font.Strikethrough is returned as Wahr/Falsch instead of True/False. I tried following code snippet I found online but unfortunately didn't help either: ..... Dim bolVal As Variant bolVal = cell.Font.Strkethrough If CStr(bolVal ) = "False" Then ' Unfortunately this didn't help. ....... Has anybody an idea how to convert this from any language to True/False? Reto |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Boolean in VBA are returned in local language
Sorry forgot to remove the Cstr conversion.........try this
If Not bolVal Then -- Cheers Nigel "Nigel" wrote in message ... If Not CStr(bolVal) then -- Cheers Nigel wrote in message oups.com... Hi, My VBA script reads some values from cells and sends them to a webservice. I just realized that using a German Excel e.g. cell.Font.Strikethrough is returned as Wahr/Falsch instead of True/False. I tried following code snippet I found online but unfortunately didn't help either: ..... Dim bolVal As Variant bolVal = cell.Font.Strkethrough If CStr(bolVal ) = "False" Then ' Unfortunately this didn't help. ....... Has anybody an idea how to convert this from any language to True/False? Reto |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Boolean in VBA are returned in local language
Why not test the boolean directly
Why not test the Boolean directly Dim bolVal As Variant bolVal = cell.Font.Strkethrough If bolVal = FALSE Then -- HTH Bob Phillips (remove nothere from email address if mailing direct) wrote in message oups.com... Hi, My VBA script reads some values from cells and sends them to a webservice. I just realized that using a German Excel e.g. cell.Font.Strikethrough is returned as Wahr/Falsch instead of True/False. I tried following code snippet I found online but unfortunately didn't help either: ..... Dim bolVal As Variant bolVal = cell.Font.Strkethrough If CStr(bolVal ) = "False" Then ' Unfortunately this didn't help. ....... Has anybody an idea how to convert this from any language to True/False? Reto |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Boolean in VBA are returned in local language
Thanks both of you. That helped.
Regards, Reto Bob Phillips wrote: Why not test the boolean directly Why not test the Boolean directly Dim bolVal As Variant bolVal = cell.Font.Strkethrough If bolVal = FALSE Then -- HTH Bob Phillips (remove nothere from email address if mailing direct) wrote in message oups.com... Hi, My VBA script reads some values from cells and sends them to a webservice. I just realized that using a German Excel e.g. cell.Font.Strikethrough is returned as Wahr/Falsch instead of True/False. I tried following code snippet I found online but unfortunately didn't help either: ..... Dim bolVal As Variant bolVal = cell.Font.Strkethrough If CStr(bolVal ) = "False" Then ' Unfortunately this didn't help. ....... Has anybody an idea how to convert this from any language to True/False? Reto |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change German language data into Eglish Language in a colum | Excel Discussion (Misc queries) | |||
language support in excel sheet using a third party language tool | Excel Worksheet Functions | |||
Language of the local PC | Excel Programming | |||
How to change the excel format from language to language? | Excel Discussion (Misc queries) | |||
Reference styles and local/non-local formulae - international problems. | Excel Programming |