Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-11-2022, 10:41 AM
Marcosnilsson Marcosnilsson is offline Word relative link to OLE objects from Excel Windows 11 Word relative link to OLE objects from Excel Office 2021
Novice
Word relative link to OLE objects from Excel
 
Join Date: Nov 2022
Posts: 3
Marcosnilsson is on a distinguished road
Default Word relative link to OLE objects from Excel

Hi!
I have been trying to understand the explanations about link of OLE objects in word documents and relative links (or re-link with macro after changing path) in several forums and posts, but I am not able to understand the solutions explained, even trying the macro solutions.
I will try to explain my problem clearly:
• I have a folder structure with word files that have pasted links to excel data from a single excel file located in a constant location in the same folder structure.
• The folder structure and files located inside have constant file names, but are copied to different locations (other folders for different projects).
• In the new location, excel file needs to be populated with different dada, and I need that the wor documents change links to this file.
I understand that this could be done making relative routes, or applying the macro attached in this post (coming from other post about the same topic), but I am not able to make it work.
I know that I could change one by one the source of every link, but I have like 10 word documents, and for every document like 20-30 linksÂ… so it is not practical to do it manually.
I provide attached an example of two folders that are directly located in my desktop:
• C:\Users\mnilsson\Desktop\A\AA\AAA
• C:\Users\mnilsson\Desktop\Location 1\A\AA\AAA
The word document with the links provided as example is named “M”


The part of the path that always keeps constant is: A\AA\AAA
The final goal is that using a macro, the file named “M”, located in folder “Location 1”, pick data from the excel file “A” located in the same foledr “Location 1” (currently, it takes them from excel file “A” located in folder “A” directly located in desktop.
Is It possible to write properly the macro, so it will works for me?
Could somebody copy the macro solution mentioned above, but populated with the data for the example provided, so I can see the data changed in macro, and then understood how to do it by myself?
If it works, I expect that in word file “M” located in folder structure “Location 1”, would have written:
• Location1
• Location2
• Location3
Instead of A1, A2, A3.
Thanks for your help, would be really appreciated!
Marcos
Attached Files
File Type: zip A.zip (29.6 KB, 3 views)
File Type: zip Location 1.zip (67.5 KB, 3 views)
File Type: zip AutoFldUpdt (1).zip (1.8 KB, 4 views)
Reply With Quote
  #2  
Old 12-01-2022, 08:52 AM
Marcosnilsson Marcosnilsson is offline Word relative link to OLE objects from Excel Windows 11 Word relative link to OLE objects from Excel Office 2021
Novice
Word relative link to OLE objects from Excel
 
Join Date: Nov 2022
Posts: 3
Marcosnilsson is on a distinguished road
Default

Hi! Nobody can help me?
Reply With Quote
  #3  
Old 01-19-2023, 03:17 AM
Marcosnilsson Marcosnilsson is offline Word relative link to OLE objects from Excel Windows 11 Word relative link to OLE objects from Excel Office 2021
Novice
Word relative link to OLE objects from Excel
 
Join Date: Nov 2022
Posts: 3
Marcosnilsson is on a distinguished road
Default

Hi! I see that after 2 months nobody can help, so I can conclude that previous solutions provided in other thread in fact do not work, and what happens is that microsoft is not able to provide an actual solution. The solutions provided up to date do not solve the problem with OLE links, and only work when the folder structure is kept constant. No option to work in the cloud with OLE objects, or using documents as templates when they have OLE objects linked, because the routes are absolute, then and a big issue working with microsoft word!
Reply With Quote
  #4  
Old 01-19-2023, 04:00 PM
Guessed's Avatar
Guessed Guessed is offline Word relative link to OLE objects from Excel Windows 10 Word relative link to OLE objects from Excel Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

You mentioned other forums and posts but didn't provide links to them so people like me didn't bother investigating as I figured you had other avenues to explore.

If you include links to the other locations where you have sought and received suggestions then perhaps someone can pool the collective wisdom to work out a solution for you.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 01-19-2023, 07:59 PM
macropod's Avatar
macropod macropod is offline Word relative link to OLE objects from Excel Windows 10 Word relative link to OLE objects from Excel Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

I had not seen your posts before today.

The solution in https://www.msofficeforums.com/word/...nal-files.html is self-explanatory. I see you've even copied the zip file with the macro from there. This cannot be solved with field coding and, contrary to your assertion, the macro solution does work.

It's not apparent to me what effort you've made to implement the macro code. Merely saying "I am not able to understand the solutions explained, even trying the macro solutions" does not evince any significant effort. If the Word document and Excel workbook are stored in the same folder, the code should run just fine out-of-the-box, so to speak. Hence:
Quote:
Originally Posted by Marcosnilsson View Post
Could somebody copy the macro solution mentioned above, but populated with the data for the example provided, so I can see the data changed in macro, and then understood how to do it by myself?
completely misunderstands the solution, since no additional coding on anyone's part would be required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
@Macropod Macro VBA LINK Fields Relative Paste Special as Image from Excel word bug ggll Word 0 09-18-2021 11:48 PM
Word relative link to OLE objects from Excel Word relative link to excel - How can you explain this ? SamVDS Word 6 04-10-2020 01:41 AM
Embed Excel file in Word: Others can't update the link. Objects are not available Lisale Word 3 03-12-2019 03:25 AM
Word relative link to OLE objects from Excel Relative link (same folder) from Excel cell into Word file SparFuX Word 1 12-18-2018 03:22 PM
Word relative link to OLE objects from Excel Relative path for video link? Is it possible? Baudisson PowerPoint 1 01-10-2012 02:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft