1 / 8

Macro for Converting Amount to Word

Read on to download, install and use the Excel function -Amount to Words. The most comprehensive function for India. 16 parameters.t<br>https://efficiency365.com/2017/01/02/amount-to-words-macro/<br>

Download Presentation

Macro for Converting Amount to Word

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Macro for Converting Amount to Word https://efficiency365.com/2017/01/02/amount-to-words-macro/

  2. Macro for Converting Amount to Word

  3. Macro for Converting Amount to Word Here is a new year gift for the Indian customers. Converting Amount to Words is always a problem. Many application require it and that code is always written manually, within the application. What is really needed is a comprehensive Excel function. Many people have written lots of Excel functions. But neither of them is specific to India, nor is it comprehensive. We (Raj and me) had created it in 2005, but I had forgotten to publish it on the blog. We have done good amount of testing – but still you have to use it at your own risk. No guarantees. Read on todownload, install and use the Excel function.

  4. Contents • Amount to Words installation instructions • Developers can use the VBA code • How to use Amount to Words Add-in • Amount to Words function syntax • Practical usage of Amount to Words Macro • JavaScript version for developers on GitHub • Feedback or wish-list

  5. Amount to Words installation instructions This macro will work on Excel 2010 onwards. • Download the Amount to Words macro file XLSM as a ZIP formatfrom here. • Unzip it in a new directory (folder). • You will see a file called Amount2Words2017 V8.xlsm • Double click to open the file. • You may see the Enable Macros dialog. Choose Enable. • DO NOT use the file as it is. It will NOT work. • You must save it as an add-in first. • Choose File – Save As and choose the type XLAM

  6. Amount to Words installation instructions 9. The path will automatically change to the appropriate Add-in folder. 10. DO NOT change the path. 11. Once the file is saved, close the XLSM file. You don’t need it any longer. 12. Now go to File – Options dialog. 13. Choose Add-ins option. 14. At the bottom you will see the Excel Add-ins dropdown. 15. Choose the Go.. button

  7. Amount to Words installation instructions 16. Now you will see a list of Excel Add-ins. 17. Select or activate the checkbox showing Amount to Words Function 18. Click OK 19. The add-in is installed. 20. Just to be on the safer side, close and re-open Excel 21. Now the Amount to Words functionality is available across all Excel files in your login (profile) Why did I not provide the XLAM file directly? Because, many users make a mistake while storing the add-in in the right place. The method shown above ensures that it is saved in the right place.

  8. Developers can use the VBA code While the XLSM file is open, you can press Alt-F11 to view the code and reuse it if you like. Please give a link to my blog as attribution. Thanks. Read more….

More Related