wrddoc

Im trying to drawing some lines, shapes in Word doc from Excel. Can i do that? Is it some tool like Canvas? Im connectiong with Word like below: Sub ExcelWord() Set wrdApp = GetObject(, "Word.Application") Set wrdDoc = wrdApp.ActiveDocument With wrdDoc 'code here End With Set...

Hello All, I have an Excel template where we house project timelines (dates started, dates ended, etc). I need to get those dates into Word at particular bookmarks. I am not sure what the most efficient way to do this is, but I started out by creating a UserForm where the user inputs the unique...

Hi, Need to copy Range from excel and paste into a word document. will probably have to copy 2 or 3 ranges so may have to repeat the process Sub CopyRange() Range ("MyDatatoCopy") Dim wrdApp, wrdDoc Set wrdApp = CreateObject("Word.Application") Set wrdDoc =...

Hello All, I am looking to improve the output of this small VBA code below. At this point I can copy and paste values without being a table in Word (Unformatted text). Keep in mind the example shows only 3 cells, but I am looking at over 40 cells over a few worksheet. Now I want to add a...

Hello All, I am looking to improve the output of this small VBA code below. At this point I can copy and paste values without being a table in Word. Now I want to add a carriage return or more between cells values. Example.: A2 = ABC, B2= DEF, C2= GHI The output in Word will be: ABC DEF GHI...