KrishTalk.com

The below code will help you to copy the MS Excel data into MS Word. The main thing to note here is, the Excel data is copied into Word in a table format. This is a very basic VBA code, you can extend this to add other features. To add this code to your excel, Open VBA editor in Excel or you can press F11. Insert a module, paste this code. Come back to excel by pressing F11 again. Under macros you can see the name of subroutine 'CopyFromExcelToWord' appearing, this is your macro. Sub CopyFromExcelToWord()    Dim objWord    Dim objDoc    Dim objRange    Dim total_rows    Dim total_cols    Dim objTable    Dim tmp_row    Dim tmp_col     total_rows = Cells(1, 10).Value     total_cols = Cells(2, 10).Value     Set objWord = CreateObject("Word.Application")   Set objDoc = objWord.Documents.Add   Set objRange = objDoc.Range   objWord.Visible = True ...

This VBA code will help you to import data from a text file and insert it into the MS word document. This is useful when you have to create a report or formats in MS Word format, reading the data from a text file. The VBA code can be extended import extra data from the text file, and also you can add additional format as per your needs. Please note that VBA macros can cause harm to your computer. First, open them in a disabled mode. To disable macros, to Developer tab, select macro security and then select Macro settings on the left side pane. In the right pane, select the second radio button, 'Disable all macros with notification'. The second option is better because it will notify you if there are any macros associated with your file. So you will not miss any document features that may be available after running a macro. But you can decide whether to allow the macros to run or not. Please click on the below link to download the MS Word Template file. You can also download...

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. 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...

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

Last week, Reliance had extended its Jio preview offer for Samsung galaxy users. A lot of people are itching to get one with a preview offer. This offer gives you unlimited 4g data, unlimited voice, and unlimited SMS for 90 days. I am one of the lucky guys to get a new Jio SIM with my Samsung Galaxy A5 2016. I got it on Saturday evening at 7 O’clock and the guy at Reliance digital said it will be activated by Monday afternoon. But I got it activated on Sunday, 2 O’ clock itself. That was very quick. How to get the preview offer with Samsung galaxy mobiles First, you need to install the Jio app called MyJio. As soon as you open the app, on the very first screen, you will see Get Jio Preview Offer on top of the screen. Click this and proceed with the other steps. In the first screen after clicking Get Jio Preview Offer, you will see the details for the offer and terms and conditions. Click "Agree and get Jio Offer". Next, you will have to check the eligibility....

There are many situations you may want to automate the MS Word document creation. In my previous posts, I have explained how to automate document generation using VBA. It was to create a new document. Every time you run the VBA code, it will create a new MS Word file. How to create a template in MS Word Now, I will explain how to insert a text file into the document as is at a specified location into an existing document. This is very useful if you are modifying an existing document. The main feature of this VBA is, it can insert new content at a specific location. That means you can insert new content into any part of the existing document, not just append the new content at the end of the file. The first step is to create a bookmark in the word document where the text file content will be pasted. Then, open the text file using VBA code and paste the content at the bookmark. Save the file with a different name. Before saving optionally you can remove the bookmark. Below vide...