Excel to Word -> VBA -> Canvas?

[pop3k]

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 wrdDoc = Nothing
Set wrdApp = Nothing


End Sub

 

[Johnny C]

You use VBA to add the lines and shapes, you don't need any external tools.

Are the shapes already in Excel? if so you copy and paste them
e.g.

    Sheets("MySheet").Shapes("Shape 1").Copy
    wordSelection.PasteSpecial Link:=False, DataType:=wdPasteShape, Placement:=wdInLine, DisplayAsIcon:=False

However ... Word is, tbh, a right pain in the proverbial. You need to insert bookmarks into your Word doc wherever you want stuff pasted or pick specific paragraphs. Working with page and line numbers is tricky to say the least, as Word treats page numbers as a function of printing so aren't easily accessible.

That's not very helpful, I appreciate, but I've wasted days trying to get stuff to copy between Excel and Word. And given up in the end.

If you have the option, it's far easier to work with PowerPoint than Word as you can pick specific slides and code where you want things pasted.

 

[pop3k]

No, i havent shapes already in Excel, i want to draw it to Word from Excel code I through make it in some application like Canvas.
Thanks anyway