tuxman
-
Total Posts
:
4
- Scores: 0
-
Reward points
:
0
- Joined: 11/4/2011
-
Status: offline
|
Convert from VBA to VBScript
Wednesday, February 01, 2012 1:16 AM
( permalink)
Hello ! I want to convert this function from VBA to VBS: Function Convert_Decimal(Degree_Deg As String) As Double
' Declare the variables to be double precision floating-point.
Dim degrees As Double
Dim minutes As Double
Dim seconds As Double
' Set degree to value before "°" of Argument Passed.
degrees = Val(Left(Degree_Deg, InStr(1, Degree_Deg, "°") - 1))
' Set minutes to the value between the "°" and the "'"
' of the text string for the variable Degree_Deg divided by
' 60. The Val function converts the text string to a number.
minutes = Val(Mid(Degree_Deg, InStr(1, Degree_Deg, "°") + 2, _
InStr(1, Degree_Deg, "'") - InStr(1, Degree_Deg, _
"°") - 2)) / 60
' Set seconds to the number to the right of "'" that is
' converted to a value and then divided by 3600.
seconds = Val(Mid(Degree_Deg, InStr(1, Degree_Deg, "'") + _
2, Len(Degree_Deg) - InStr(1, Degree_Deg, "'") - 2)) _
/ 3600
Convert_Decimal = degrees + minutes + seconds
End Function But I dont'know how to convert "Val" function. So please help me Thank you very much in advance
|
|
|
|
ebgreen
-
Total Posts
:
8219
- Scores: 98
-
Reward points
:
0
- Joined: 7/12/2005
-
Status: offline
|
Re:Convert from VBA to VBScript
Wednesday, February 01, 2012 2:13 AM
( permalink)
You don't need to convert the Val function. Just get rid of it. Also get rid of all the "as Double" instructions. Also get rid of "As String" in the function parameter. Try that first and we will work out any errors that you still get.
|
|
|
|