VBA syntax error on "replace" function (replace character in string)

[j_steenbergen]

I have a string in which I'd like to replace commas with a dot. Normally in VBA you would use:

Dim s As String
s = "15,6kg"
s = Replace(s, ",", ".")

Except that I get a syntax error on the replace function. Pretty weird, because it is listed as function in the Inventor VBA object browser. Auto correct also makes the r from replace lower case so it somehow doesn't recognize it.

It seems with iLogic a similar syntax is working:

https://forums.autodesk.com/t5/inventor-customization/ilogic-rule-replace-character-in-string/m-p/48...

So am I doing something wron or is this a bug?

[bradeneuropeArthur]

Are you using this in I-logic or in VBA?

[j_steenbergen]

I'm using VBA (see title)

[bradeneuropeArthur · Accepted solution]

Than use this:

Public Sub main()

Dim s As String
s = "15,6kg"
s = VBA.Replace(s, ",", ".")

MsgBox s
End Sub

[j_steenbergen]

Wow, that did the trick. Thanks!

[TobFischer94]

... and how would it be possible in iLogic?

Nevermind, i found out, the following text did the trick for me. In my example, "param" is the numeric value with a comma, and "Variable" is the string that gets converted with a period

Variable = param
Variable = Replace(Variable, ",", ".")

[bradeneuropeArthur]

Public Sub main
	
Dim st As String = "aba"

st = Replace(st,"b","c")
MsgBox (st)
End Sub

Public Sub main()

Dim s As String
s = "15,6kg"
s = Replace(s, ",", ".")

MsgBox s
End Sub

[maxim.teleguz]

this right here is what i have been searching for the last 5 years. 

[maxim.teleguz]

you can shorten it like so:

Public Sub main

Dim st As String = Replace(st,"b","c")

MsgBox (st)
End Sub

or my code and how i used it:

a = 'pass on your string here from your code

Dim TXT2Find As String = "Precision='2'"
Dim NewTXT As String = "Precision='3'"
		
If a Like NewTXT Then
MsgBox("nothing changed")
Exit Sub
Else
a = Replace(a, TXT2Find, NewTXT)
End If