I'll spare the details but essentially I want to make a study guide or book for language learning purposes. I was wondering if there was a quick and easy way (or even difficult way lmao) to quickly export cells to a Word document following some specific format? I made an example Excel and Word document to explain better, but don't worry, I won't keep it in that format haha it's ugly. I just want to know if there's a way to take information from a cell and paste it onto a specific line in Word etc. Would I have to write some script...? Any help would be appreciated!
This screenshot shows what I am trying to do.
EDIT I tried to do some VBA but I'm lost.
Sub dataToWord()
Dim wordApp As Word.Application
Dim templateFile As Object
Dim c As Integer
On Error Resume Next
Set wordApp = GetObject(, "Word.Application") 'gives error 429 if Word is not open
On Error GoTo 0 'stop ignoring errors
If wordApp Is Nothing Then
Set wordApp = CreateObject("Word.Application") 'creates a Word application
End If
wordApp.Visible = True
Set templateFile = wordApp.Documents.Open(ThisWorkbok.Path & "/" & Range("E1").Value & ".docx")
wordApp.Visible = True
c = 2
For i = 1 To 3
templateFile.ContentControls(i).Range.Text = Sheets("Data").Cells(2, c)
c = c + 1
Next i
wordApp.Documents.Close
wordApp.Quit
End Sub
The Excel and Word documents I'm using look like this
I was looking at tutorials and found Mail Merge as well so I might just do that.
EDIT 2
Moved on the using Mail Merge but having trouble with accent marks. The problem is that the letters show as an underscore See here