Select the VBA code from the “File — Open” dropdown menu in the top of your Excel window. The worksheet is created, the selected data is visible and ready to be imported (or converted) into the new sheet (Sheet1”)3. When you want to go back to Excel, go to View — Format & tab — Select “Inline Office Formatted Text” and click “OK”4. After doing this, the next time you import a new data, a few of the lines will be removed in the spreadsheet and the next time, it will work. Import data from Excel into Word Automatically Using VBA (2) Now, we can have the data in separate sheets for reading and manipulation. We imported the data with Excel in Word. A sheet with two columns is used as a file table. We can use the VBA code to define the columns in the file and a range of columns is imported into Excel. VBA worksheets — Excel v8.5 — Create a new sheet name and choose one of the two formulas or a list of formulas.5. Using the above approach, the sheet will be created and created files of data are imported. Now, we can move the tables to different sheets. If we want to convert the data into a list, we can convert from List of cells (Sheet1) into Excel cell range. We have to copy and paste the range of the list in cells of Sheet1 and paste the data into the spreadsheet, which is now working correctly. We can also convert the list to rows and paste it into Sheet2. But now we need to convert the data into numbers. We can use this formula: Excel VBA to import table from Excel to Word — Excel dome Create a new sheet name and choose an Excel functions function to copy and paste into its range (Excel range). The function is “Get-Range”. The function can be changed the following way: VBA: Import data from Excel into Word | Excel dome Import Data: Word to Excel VBA worksheets — Excel v8.