Amount convert to Words using VB Code

Hi Guys,

I need formula from where Rs. 100,000/- needs to be converted as Rupees One Lacs Only.

I got some code but it is working once.

It is not working in other excel file as it is showing that it is not available.

I tried to copy and paste in other file but still it is not working.

I want that the same VB code can be available in all spreads sheet.

Is anyone help me in this regard?

If you want to use the same VB code in all spreadsheet you need to put it in your personal.xls file.

http://office.microsoft.com/en-gb/ex...102174076.aspx

Thanks for reply.

But i want VB code where this formula can be available in all spread sheet/excel file.

Yup thanks.

Dear i am looking that that formula can be worked in any excel file.

Normally Once I ll update VB code in one excel file (say File A), VB code is not available in another file (say File B).

I want that SpellNumber formula can be available in all excel file.