{"id":12116,"date":"2012-01-08T17:19:16","date_gmt":"2012-01-08T17:19:16","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1179"},"modified":"2017-07-18T13:04:44","modified_gmt":"2017-07-18T13:04:44","slug":"copy-from-excel-and-paste-in-word","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/","title":{"rendered":"Macro to Copy from Excel in to Word Document"},"content":{"rendered":"<p>In Previous Article we saw <a href=\"https:\/\/vmlogger.com\/excel\/2012\/01\/how-to-copy-content-from-word-using-vba\/\" target=\"_blank\">how to Copy Content from a Word Document and Paste in in to the Active Workbook.<\/a> Now in this Article i am going to write a function will Select a Range from Excel and paste the content in a New Word Document.<br \/>\nHere there are two possible way of copying and pasting in Word Document. Also while pasting in the word Document you can format the Doc as per your requirement. Below 3rd point describe about that.<\/p>\n<ul id=\"recentposts\">\n<li>\n<a href=\"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/#copy-as-text-and-paste-in-word\">Copy only the Content and paste it in Word Document as Content. <\/a>\n<\/li>\n<li>\n<a href=\"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/#copy-as-picture-and-paste-in-word\">Copy the Excel Range as Picture and paste it in word Doc.<\/a>\n<\/li>\n<li>\n<a href=\"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/#font-settings-while-pasting\">Formatting in Word While pasting Copied Range from Excel<\/a>\n<\/li>\n<\/ul>\n<p><a name=\"copy-as-text-and-paste-in-word\"><\/a><\/p>\n<h1>1. Copy only the Content and paste it in Word Document as Content. <\/h1>\n<pre><code class=\"language-vbnet\">\r\nSub CopyToWord()\r\n\r\n    Dim objWord As New Word.Application\r\n    'Copy the range Which you want to paste in a New Word Document\r\n    Range(&quot;A1:B10&quot;).Copy\r\n\r\n    With objWord\r\n        .Documents.Add\r\n        .Selection.Paste\r\n        .Visible = True\r\n    End With\r\n\r\nEnd Sub\r\n<\/code><\/pre>\n<p><a name=\"copy-as-picture-and-paste-in-word\"><\/a><\/p>\n<h1>2. Copy the Excel Range as Picture and paste it in word Doc. <\/h1>\n<pre><code class=\"language-vbnet\">\r\nSub CopyToWord()\r\n\r\n    Dim objWord As New Word.Application\r\n    'Copy the range Which you want to paste in a\r\n    ' New Word Document as a Picture\r\n    Range(&quot;A1:B10&quot;).CopyPicture xlPrinter\r\n\r\n    With objWord\r\n        .Documents.Add\r\n        .Selection.Paste\r\n        .Visible = True\r\n    End With\r\n\r\nEnd Sub\r\n<\/code><\/pre>\n<p><a name=\"font-settings-while-pasting\"><\/a><\/p>\n<h1>3. Font Formatting of Word Document while pasting <\/h1>\n<pre><code class=\"language-vbnet\">\r\nSub CopyRangeToWord()\r\n\r\n\tDim objWord As New Word.Application\r\n\tDim objDoc As New Word.Document\r\n\r\n\tSet objDoc = objWord.Documents.Add\r\n\tobjWord.Visible = True\r\n\tRange(&quot;A1:B10&quot;).Copy\r\n\t With objDoc.Paragraphs(objDoc.Paragraphs.Count).Range\r\n           'All formatting goes here\r\n\t    .Paste\r\n\t    .Font.Name = &quot;broadway&quot;\r\n\t    .Font.Color = wdColorBlue\r\n\t    .Font.Bold = True\r\n\t    .Font.Italic = True\r\n         .Font.Allcaps = True\r\n         .Font.Size = 20\r\n\tEnd With\r\n\r\nEnd Sub\r\n<\/code><\/pre>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>In Previous Article we saw how to Copy Content from a Word Document and Paste in in to the Active Workbook. Now in this Article i am going to write a function will Select a Range from Excel and paste the content in a New Word Document. Here there are two possible way of copying [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1246],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.9 (Yoast SEO v21.9.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Macro to Copy from Excel in to Word Document - Let&#039;s excel in Excel<\/title>\n<meta name=\"description\" content=\"How to Copy a range from Excel Sheet and Paste it in a New Word Document. Basically this function will copy selected range and open a New Word Doc and paste the Copied Content in to the Word Document.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Macro to Copy from Excel in to Word Document\" \/>\n<meta property=\"og:description\" content=\"How to Copy a range from Excel Sheet and Paste it in a New Word Document. Basically this function will copy selected range and open a New Word Doc and paste the Copied Content in to the Word Document.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/\" \/>\n<meta property=\"og:site_name\" content=\"Let&#039;s excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2012-01-08T17:19:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-07-18T13:04:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Macro to Copy from Excel in to Word Document\",\"datePublished\":\"2012-01-08T17:19:16+00:00\",\"dateModified\":\"2017-07-18T13:04:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/\"},\"wordCount\":155,\"commentCount\":7,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"articleSection\":[\"Excel Macro\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/\",\"name\":\"Macro to Copy from Excel in to Word Document - Let&#039;s excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"datePublished\":\"2012-01-08T17:19:16+00:00\",\"dateModified\":\"2017-07-18T13:04:44+00:00\",\"description\":\"How to Copy a range from Excel Sheet and Paste it in a New Word Document. Basically this function will copy selected range and open a New Word Doc and paste the Copied Content in to the Word Document.\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Macro to Copy from Excel in to Word Document\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let&#039;s excel in Excel\",\"description\":\"Let&#039;s share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/twitter.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Macro to Copy from Excel in to Word Document - Let&#039;s excel in Excel","description":"How to Copy a range from Excel Sheet and Paste it in a New Word Document. Basically this function will copy selected range and open a New Word Doc and paste the Copied Content in to the Word Document.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/","og_locale":"en_US","og_type":"article","og_title":"Macro to Copy from Excel in to Word Document","og_description":"How to Copy a range from Excel Sheet and Paste it in a New Word Document. Basically this function will copy selected range and open a New Word Doc and paste the Copied Content in to the Word Document.","og_url":"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/","og_site_name":"Let&#039;s excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2012-01-08T17:19:16+00:00","article_modified_time":"2017-07-18T13:04:44+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png","type":"image\/png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Macro to Copy from Excel in to Word Document","datePublished":"2012-01-08T17:19:16+00:00","dateModified":"2017-07-18T13:04:44+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/"},"wordCount":155,"commentCount":7,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"articleSection":["Excel Macro"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/","url":"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/","name":"Macro to Copy from Excel in to Word Document - Let&#039;s excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"datePublished":"2012-01-08T17:19:16+00:00","dateModified":"2017-07-18T13:04:44+00:00","description":"How to Copy a range from Excel Sheet and Paste it in a New Word Document. Basically this function will copy selected range and open a New Word Doc and paste the Copied Content in to the Word Document.","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2012\/01\/copy-from-excel-and-paste-in-word\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"Macro to Copy from Excel in to Word Document"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let&#039;s excel in Excel","description":"Let&#039;s share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/twitter.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12116"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12116"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12116\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}