Hello,

with the help of some Youtube videos i was able to write a small excel macro to help me copying content from my excel table into a word document (by using bookmarks for example).
The macro works fine: it is able to copy the content from the excel sheet to the word document. The problem is: subscript- and superscript-numbers and -letters are turned into normal letters. IF possible i would like to change that.

This is the code is used:

Sub nachwordkopieren()

Dim Probenliste As Object
Dim appWord As Object

Set appWord = CreateObject("Word.Application")
Set Probenliste = appWord.Documents.Add("filepath")

appWord.Visible = True

Probenliste.Activate
Probenliste.Bookmarks("Probenname1").Range.Text = Range("Probenname1")
Probenliste.Bookmarks("Verbindung1").Range.Text = Range("Verbindung1")

Set Probenliste = Nothing
Set appWord = Nothing

End Sub

Keep in mind i am no expert^^


Any ideas are appreciated

Greetings!