Use and link multiple excel-objects in a word-document

Ventura Alfio · 2. Juni 2023

Dear Microsoft-Support,Case description: We have a project where a lot of text information as well as data has to be combined and regularly updated in parallel.In the current solution, there is a Word document for the text information and an associated Excel document for data, data processing and charts.Since it is somewhat cumbersome to have to jump back and forth between the two documents, e.g. in MS teams meetings, I would like to integrate the two with each other to avoid back and forth between the programs.My current solution approach: I either A use the linking function to integrate Ex

Raffaele Serravalle

Hi mschwani,

Needs a bit of code but it can be done. The below is a mix of previously answered question and useful how to links:

https://answers.microsoft.com/en-us/office/foru...

https://answers.microsoft.com/en-us/office/foru...

https://www.msofficeforums.com/word-vba/20788-r...

https://wordmvp.com/FAQs/MacrosVBA/BatchFR.htm

https://www.extendoffice.com/documents/word/100...

https://www.extendoffice.com/documents/word/583...

Hope the information provided is useful. If the issue persists or have any other questions, reply here and I will be glad to help you.

Kind regards,

Raffaele

External Links Disclaimer for non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any
product advertised on the site before you decide to download and install it.

Lisa Wilke-Thissen

Hallo Steven,
hier findest du Lösungsansätze:
HOW TO: Use Mail Merge to Create a List Sorted by Category in Word 2000 - Microsoft Support
https://www.youtube.com/watch?v=MIfid43hlHw
Group multiple rows from Excel to Word - Mail Merge (msofficeforums.com)
Graham Mayor stellt ein Add-In zur Verfügung:
Merge Many To One (gmayor.com)
Viele Grüße
Lisa

Andreas Killer

Ich würde statt xlOpen, wie Claus es vorschlägt, eher xlVerbPrimary nehmen. Das hat den Unterschied das das eingebettete Word-Object in Excel zum Editieren geöffnet wird, statt in einer neuen Instanz.

Wenn Du statt SELECTION das OLE-Object benutzt, dann hast Du hinterher auch sehr einfach Zugriff auf das Word-Object und kannst dann auf alle Word-Objecte direkt zugreifen, z.b. auch auf Bookmark => die Textmarke.

Aber der Programmieraufwand für sowas lohnt sich nicht, es ist einfacher und hinterher viel schneller wenn man gleich alles in eine seperate Exceltabelle kopiert und auf diese direkt zugreift.

Wenn Du auf das eingebettete Object zugreifst, dann muss immer eine Instanz der Application zusätzlich gestartet werden. Und zwar jedesmal!

Andreas.

Sub Test()

Dim Oo As OLEObject

Dim wDoc As Object 'Word.Document

Dim wBookmark As Object 'Word.Bookmark

'Search for the embedded Word document

For Each Oo In ActiveSheet.OLEObjects

If InStr(1, Oo.progID, "Word.Document", vbTextCompare) > 0 Then

'Open the embedded document

Oo.Verb xlVerbPrimary

'Get the document inside

Set wDoc = O o_O

bject

Set wBookmark = wDoc.BookMarks(1)

wBookmark.Range.Copy

Range("A1").PasteSpecial xlPasteValues

'Select any cell to close the document

Range("A1").Select

'Done

Exit For

End If

Next

End Sub

ScottBDiamond

Here is what I originally typed:

You can create form letters in Access that can read from multiple records much more easily. You can use text blocks that concatenate in data fields. and then have rows in your detail band or maybe a subreport, to display the multi-row data.

So it translated concatenate to chained and detail band to detail book.

Basically I generally create my form letters, especially ones that use multiple records, in Access. Its not hard to do and much easier to report on data that spans multiple records.

Marco Seefeldt

eine Einstellung in Microsoft Excel gibt es so nicht.

Meines Erachtens nach liegt es daran dass Microsoft Excel eine MDI Anwendung (Multiple Document Interface) ist.

Teste doch bitte die Workarounds, auch so bekommst du dann mehrere Instanzen für Microsoft Excel.

Mit freundlichem Gruss

Marco

This posting is provided "AS IS" with no warranties and confers no rights.

Hi,

willkommen im Windows Forum!

Use and link multiple excel-objects in a word-document - Similar Threads - Use and link	Forum	Datum
Use a query Use a query: I have a queryHow do I use the result in a Sheet? Copilot could not help me here.	Microsoft Office	25. Juni 2025
Open Documents with multiple Microsoft Accounts Open Documents with multiple Microsoft Accounts: Hello MS Community,We are facing an issue with users who have multiple Microsoft accounts e.g., one for work and one for school and are signed into Office with both accounts. This leads to...	Microsoft Office	16. Oktober 2024
How to create a short link to a document on Sharepoint? How to create a short link to a document on Sharepoint?: We need a way to put short links to further reading documents on our PRINTED One-Pagers, Internal Bulletins and Executive Summaries.How is anyone, let alone an executive, going to be able to TYPE...	Microsoft Office	9. Januar 2024
Links in Word document to Excel file do not work anymore with Office 365 Object not found... Links in Word document to Excel file do not work anymore with Office 365 Object not found...: Hi all,I have a huge problem that no one has been able to solve so far. It is a big blocker for my daily work in our startup and it makes the cloud version of Office currently a disappointment...	Microsoft Office	31. Dezember 2023
Visio: Multiple Off Page Links to a Single target. Visio: Multiple Off Page Links to a Single target.: I am drawing a fairly complex process diagram which will have three "happy path" flows each is a separate diagram.The "off normal" flow represents error conditions. This flow can be "called" from...	Microsoft Office	11. August 2023
excel-tabelle in word-document excel-tabelle in word-document: Wenn ich in einem Word-Dokument eine Excel-Tabelle einfüge und öffne, dann öffnet sich neuerdings ein neues Fenster. Dadurch kann ich die Größe der Tabelle in Word nicht mehr ändern. Ich hätte...	Microsoft Office	13. September 2019
use a paysafecard use a paysafecard: Dear lovely Community, I´ve got a little problem. sadly I listen to a friend who said to me, that I am able to pay in the Xbox store at my Win10 Pc with Paysafecards. To buy Forza 7 Ulitmate I...	Games und Spiele	16. Oktober 2018

Use and link multiple excel-objects in a word-document

Use and link multiple excel-objects in a word-document

Microsoft Word - Replace Header/ Footer

Dynamische Tabelle in Seriendruck-Brief erstellen

In einer Excel-Datei ist eine Word-Datei als Objekt hinterlegt.

ACCESS-Export-Tabelle (für Word-Serienbriefdatei), die pro Zeile eine Tabelle enthält

mehrere Excel Instanzen öffnen

User Advert

Use and link multiple excel-objects in a word-document - Microsoft Office

Use and link multiple excel-objects in a word-document - Similar Threads - Use and link

Use a query

Open Documents with multiple Microsoft Accounts

How to create a short link to a document on Sharepoint?

Links in Word document to Excel file do not work anymore with Office 365 Object not found...

Visio: Multiple Off Page Links to a Single target.

excel-tabelle in word-document

use a paysafecard

Use and link multiple excel-objects in a word-document solved