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 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.
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
objDoc.Tables.Add objRange, total_rows, total_cols
Set objTable = objDoc.Tables(1)
objTable.Borders.Enable = True
For tmp_row = 1 To total_rows
For tmp_col = 1 To total_cols
objTable.Cell(tmp_row, tmp_col).Range.Text = Cells(tmp_row, tmp_col)
There are situations where you may have to copy and paste some content from excel to word. And save the newly created document into disk. Th...
Normal phone Bluetooth headset can be easily connected to a laptop and it can be used as earphone or headphone while using skype, gtalk, wha...
There are plenty of online resources to convert Numeric currencies to Text- from $200 to Dollar Two Hundred. But this is applicable only ##...
MS Excel currency converter 3.0 has been updated with bug fixes. This is the new version of my amazing currency converter VBA utility for MS...