Posts

MS Excel Currency converter VBA code

To convert numbers into text, there is no  builtin function in MS Excel as of now. Using the below VBA code you can overcome this issue. There are situations like writing a cheque leaf, printing a rent agreement, or writing contract documents that may require printing the transaction amount in the text. Make use of this code to convert numbers into text automatically.  Copy and paste this VBA code into your Excel VBA editor module. Or Insert an empty module and paste this code. Attribute VB_Name = "Module1" 'Attribute VB_Name = "Module2" ' ****  Author          : Krishna S ' ****  Tittle          : Converting Hindu Arabic Currency(Indian System) to Words ' ****  Copyright Owner : Krishna S ' ****  Description     : This utility converts currencies in Indian numbering system to words. ' ****  Limitations     : Converts only upto 10,00,00,000( Ten Crores) Function C...

How to merge 2 or more MS word documents

How to merge 2 or more MS word documents. You can do this by manually copying the first file and pasting on to the second file. But if you have too many files to merge and if you have to do it repeatedly, it's better to have automated setup. Below macro will help you to merge 2 documents. You can edit the VBA code and add more files if you want. After merging, it will save as a new document. By default, it will save the new merged file under My Documents. If you want the new files to be saved under a specific location, you can mention that the file name section Sub Merge_2_files() ' Merge 2 files and save as a new document NewFileName = "NewFile_" & Minute(Now) & "_" & Second(Now) & ".docx"     Selection.EndKey Unit:=wdStory     Selection.TypeParagraph     Selection.InsertFile FileName:="C:\Users\inksanjeev\Desktop\A folder\Specifications.docx", Range:="", _         ConfirmConversions:=False...

How to get Unlimited Jio preview offer with Redmi Note 3

If you follow these steps carefully you will get the unlimited offer with Jio on your Redmi note 3. Get the old apk of MyJio app from below link Install MyJio and then all 11 applications from the app store do not open any application Turn off your data/wifi Open the MyJio app, then click on MyJio again. You will see 3 options Get Jio SIM, Sign In and Sign Up. Select Sign in Enter your Jio ID and Password. You can generate your Jio ID by linking your Jio number with email ID on Jio.com. Do not click on Sign In. Just enter the ID and Password. Turn on the data/wifi Click on Sign In. You have to try a couple of times to get to the next screen where it will ask you to submit.  Once you get the submit button click that and that's all. Your unlimited offer is credited. Enjoy unlimited Digital life for 3 months. Please your story on the comments below. https://drive.google.com/open?id=0B4UB3eOhhY26eFdzVWViZU5EWGM