MICROSOFT WORD 15.0 MANUAL

Word application will be launched immediately & data will be copied from all the worksheets into word refer below snapshot.

After setting up the data in worksheets we can run the macro.

Following is the snapshot of both the worksheets:

To test the code, let us insert 2 sheets & add random numbers. If Not ws.Name = Worksheets(Worksheets.Count).Name Then WdDoc.Paragraphs().Range.InsertParagraphAfter Copy the below code in the standard moduleДim wdApp As Word.Application, wdDoc As Word.Document, ws As WorksheetДЄpplication.StatusBar = 'Creating new document.'ДЄpplication.StatusBar = 'Copying data from ' & ws.Name & '.'.Make sure you check the box refer below image.Scroll down till you find вЂњMicrosoft Word 15.0 Object LibraryвЂќ.There is an important step which you must not miss.To get the code we need to follow the below steps to launch VB editor: With macro code, you can simply copy the data in one worksheet at one time & then word application will be launched automatically & VBA code will use paste command to insert the data into doc file. We will automate the whole procedure via VBA code. In this article, we will focus on moving data from excel to word document.

MICROSOFT WORD 15.0 MANUAL

We all transfer data from excel to word manually which becomes tedious sometimes when it comes to performing the same steps too many times in a day in order to avoid the manual steps, we will write VBA code to do all the steps.

However, excel data can be copied & pasted into word & then saved as word document. Word application cannot open excel files directly. In excel, there is no such feature that could allow you to convert the data from excel workbook to word file. If you are required to copy & paste data from multiple excel worksheets into MS Word then you should read this article.

Microsoft word 15.0