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)
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...
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...
MS Excel currency converter 3.0 has been updated with bug fixes. Below are the list of bugs fixed 1. For 1000 and 100000 it was resultin...
There are plenty of online resources to convert Numeric currencies to Text- from $200 to Dollar Two Hundred. But this is applicable only ##...