Updating links in word Video chat sexi face to face
You can also create links to a blank email message or to other locations in the same document.Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange I have the following links to Excel in a word document: The issue is that when changes are made the document version on both the excel sheet referenced and the word document change. I would like to do this with a VBA macro and here is what I have so far: Sub Replace_Link() Dim i Shp As Inline Shape Dim ex Wb As Excel. Inline Shapes With Active Document Set ex Wb = obj Excel.
Name, ".docm", ".xlsm")) End With With i Shp If Not .
This works as a one-way link feed that brings the updated Excel data into the linked Word document.
Linking an Excel worksheet also keeps your Word file small because the data isn't saved in the Word document.
Then scroll down the list and look for the Microsoft Excel library and tick the box (it should then appear at the top of your list of references).