MS word automation link excel content to word automatically

2,720 views · Published 12 August 2018 · 7:02 · Indexed 11 October 2026

Channel: Krishna S · 2018 · Science & Technology

Watch on YouTube

Copy a text, table or range from excel and paste onto Word. Then save the document with a specific name. This is useful in a situations like, generating reports based on excel table. One report for each row. The macro is running in the excel itself, so you dont need to open and do anything in MS Word. Just by clicking on a button in the excel you can create a report in MS word.

Download the VBA code from the below link 

http://www.krishtalk.com/2018/08/vba-code-to-copy-and-paste-content-from.html


Subscribe to my channel:
http://www.youtube.com/user/krishnayess?sub_confirmation=1
YouTube Channel: https://www.youtube.com/krishnayess
My Blog: krishtalk.com
Google Plus: https://plus.google.com/+KrishSanj/
Twitter @iTwittt
https://twitter.com/iTwittt

More from this channel

• 5:15 How to get a list of files in folder in Excel

  Krishna S

  3,143 views · 30 June 2015

• 7:04 How to delete blank rows in Excel

  Krishna S

  3,455 views · 3 July 2015

• 7:38 How to create macro in Personal workbook

  Krishna S

  342 views · 16 August 2015

• 5:43 Copy of How to create your own Excel Add-in - Currency converter - number to text

  Krishna S

  113 views · 13 October 2015

• 3:03 How to format MS Excel cell comments

  Krishna S

  142 views · 20 November 2015

• 3:01 Spellnumber in MS Word Part 2

  Krishna S

  4,514 views · 20 November 2015

• 3:01 Spellnumber in MS Word Part 3

  Krishna S

  2,645 views · 20 November 2015

• 7:25 Excel cell referencing RELATIVE ABSOLUTE and MIXED

  Krishna S

  1,068 views · 14 January 2016