FormatNumber. Trouble is that the class is Not Creatable, though it is
Public (in VB Object Browser!).
In the documentation (XML 3) it even states there is a Visual Basic
syntax like this:
strValue = oXTLRuntime.formatNumber(dblNumber, bstrFormat)
so I tried this code:
>>>> CODE SNIPPET >>>>
Dim xmlFunc As MSXML2.IXTLRuntime
Dim xyz As Double
Dim abc As String
xyz = 1234567.89
set xmlfunc=new msxml.ixtlruntime ' DOES NOT WORK !!!
abc = xmlFunc.FormatNumber(xyz, ",")
<<<< END CODE <<<<
and it does not work. This, of course is because the class is not
without using an XSL STylesheet!
The reason is not to use it in VB of course, but in fact to use it in
format a number to currency in 1 line of code!
thanks for any help
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
|All times are GMT. The time now is 11:42 PM.|
Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.