Forum Discussion

seanrm100_'s avatar
seanrm100_
Copper Contributor
May 08, 2019

Linked Excel/Word Template?

Hey there,   I was wondering what the best practice is for dynamically linking certain tables from an Excel book to a Word doc, then copying both the Excel book and Word doc to new files, while mai...
excel
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jun 16, 2021

seanrm100_ 

 

Create a cross-reference

A cross-reference allows you to link to other parts of the same document. For example, you might use a cross-reference to link to a chart or graphic that appears elsewhere in the document. The cross-reference appears as a link that takes the reader to the referenced item.

If you want to link to a separate document you can create a hyperlink.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jun 16, 2021

NikolinoDE 

Another proposed solution with VBA.

 

Open a Word document using a command button, into which the data is inserted that can be seen on the worksheet on which the command button is located.

 

The corresponding file should be opened without any problems with the following code:

Private Sub CommandButton1_Click ()
Dim is As Object
     Dim abc As Integer
    
     Dim new Doc As Object
     Dim bAvailable As Boolean
     bVorhanden = False
    
     Set wrd = CreateObject ("Word.Application")
     wrd.Visible = True
     Set newDoc = 
wrd.Documents.Add (Template: = "S: \ XXX \ XXX \ XXX.dot")
     With new doc
        
     wrd.Selection.WholeStory 'Selects the whole document
     wrd.Selection.Fields.Update 'Updates all fields that have been entered
    
     'abc = wrd.CursorAufText

End With
wrd.Visible = True

    
End Sub

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

 

Resources