Re: Problem with Function to Convert Number To Words

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Rashid,

It came from http://pun1ww1-a.sancharnet.in:83/shaileshagrawal/down.htm
(actually the site is redirected from http://www.charteredvaluer.com )
by Shailesh Agrawa and he still has his site, but he never finished up the suggestion
to make it into a function. What I posted was a function -- I did not give it a name

Try this link (you want to look at original code, not HTML code) this is
a later posting where I placed a decent function name on the code.
http://groups.google.com/group/microsoft.public.excel/msg/244d8953bc2c0be5?dmode=source&hl=en

to see the entire thread as HTML
http://groups.google.com/group/microsoft.public.excel/browse_frm/thread/4655814d2a6b5fbe/244d8953bc2c0be5#244d8953bc2c0be5

I don't know why you could only read 1 of the 3 links provided before
they should all be the same. What browser and version are you using
and what operating system. I've not had trouble with such links not working
at Google. Though I have had problems with Google rendering code in HTML
and have to use options, original [code]

I have no trouble browsing with either
Firefox 1.0.6 or with Internet Explorer 6.0.2800.1106
running under Windows 2000 Version 5.0 (Build 2195: Service Pack 4)

Actually it is more likely to be your newsreader that is messing up, in
Outlook Express the links will wrap properly, at least for me.
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

<prkhan56@xxxxxxxxx> wrote in message news:1126588709.101798.211860@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hello David,
>
> Both the links says "Sorry document not found"
>
> the following works
> http://groups.google.com/group/microsoft.public.excel/browse_frm/thread/91c939c09e4357e4/fdfcbfb814476b90#fdfcbfb814476b90
>
> I have the code referred to in the above thread - but due to my limited
> knowledge, I dont know what to do with it....it is a Sub and not a
> Function.. so I dont know how to make it work...
> My previous code posted used to work like =CurrencyToWord(A1).. but I
> dont know how to get the Sub to work
>
> Thanks for your time
>
> Rashid Khan
>


.

Relevant Pages

  • reuse code inquiry
    ... I am a perl beginner and I am suggested to parse HTML by using ... sub parse_html { ... # incomplete tag. ... if ($routine eq "") { ...
    (comp.lang.perl.misc)
  • Re: Fails then continues without error
    ... I think the problem has to do with WORD reading the HTML ... Set TBL = IE.document.getelementsbytagname ... Set TBLRows = TBL.Item.Rows ... End Sub ...
    (microsoft.public.excel.programming)
  • Re: Auto insert code into another html page
    ... The program ets you export the project into several different html ... pages within a folder which has the same name as the project. ... I dont want to edit all the newly created project documents with the ... Other user opens my main page which displays the newly created ...
    (alt.html)
  • Re: any pointers please? combine words script
    ... use CGI qw/:standard/; ... # script is in development, ... # the html in another place ... sub get_html { ...
    (comp.lang.perl.misc)
  • Re: Auto insert code into another html page
    ... The program ets you export the project into several different html ... pages within a folder which has the same name as the project. ... I dont want to edit all the newly created project documents with the ... Other user opens my main page which displays the newly created ...
    (alt.html)