I have this problem:
I create a Word dosument with Excel VBA. Now I want to insert a graphic into the header. Since several people have to use the Excel workbook, the graphic is not saved in a separate file. Instead i have put in in an extra sheet in my workbook.
How can I put this graphic to the Word document header (and change size and position)?
To avoid misunderstandings: I do not use Word VBA entirely, only Excel VBa is used.
I have experimented with the macro recorder, but something like this does not work:
Dim objHeader As Object Worksheets("Logo").Shapes.Range(Array("Group 4")).Copy Set objHeader = wdApp.ActiveDocument.Sections(1).Headers(1) objHeader.pasteandformat
I have psoted this already here (German)
I hope for your help