1 New Message
Digest #2912
Message
Wed Jan 1, 2014 10:41 am (PST) . Posted by:
jcarlosd
I had the same problem that Markus mentioned. I fixed it few years ago and I really don't remember if I coded the solution, Randy helped me or I grabbed the code from somewhere else.
Basically, I added a new parameter to my own version of, for example, RCHGetHTMLTable. It is:
Optional sIntlSet As String = ".,"
That sIntlSet variable has two characters for marking decimal point and thousand separator.
When I access an American web, I don't need to change anything. For European webs, I specify that variable as ",.", son the decimal point is "," and the thousand separator is ".".
Inside the code of RCHGetHTMLTable finally I convert the result according to that variable with this statement:
vTemp = RegionalCDec(vTemp, sIntlSet)
RegionalCDec is a function that perhaps Randy passed me. It converts the number to the new setup. If you really need it, I can post it, though this is not a standard solution integrated in Randy's code, so it is not updated with his new versions. Perhaps, if Randy is interested, he can include it in his official version.
Juan C.
Basically, I added a new parameter to my own version of, for example, RCHGetHTMLTable. It is:
Optional sIntlSet As String = ".,"
That sIntlSet variable has two characters for marking decimal point and thousand separator.
When I access an American web, I don't need to change anything. For European webs, I specify that variable as ",."
Inside the code of RCHGetHTMLTable finally I convert the result according to that variable with this statement:
vTemp = RegionalCDec(
RegionalCDec is a function that perhaps Randy passed me. It converts the number to the new setup. If you really need it, I can post it, though this is not a standard solution integrated in Randy's code, so it is not updated with his new versions. Perhaps, if Randy is interested, he can include it in his official version.
Juan C.
Tidak ada komentar:
Posting Komentar