Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-11-2024, 05:11 AM
AlexB84 AlexB84 is offline Relative Link from Excel to Word Link Field - Macro problems Windows 10 Relative Link from Excel to Word Link Field - Macro problems Office 2021
Novice
Relative Link from Excel to Word Link Field - Macro problems
 
Join Date: Jun 2024
Posts: 2
AlexB84 is on a distinguished road
Default Relative Link from Excel to Word Link Field - Macro problems

Hi there,



I have problems using the macro from (https://www.msofficeforums.com/word/...nal-files.html).

I get many strange errors like '6083' or '5345'


and all result from this one line of code:
" .SourceFullName = Replace(.SourceFullName, OldPath, NewPath)"

Can someone help pls?

Thank you very much in advance
Reply With Quote
  #2  
Old 06-11-2024, 12:20 PM
Guessed's Avatar
Guessed Guessed is offline Relative Link from Excel to Word Link Field - Macro problems Windows 10 Relative Link from Excel to Word Link Field - Macro problems Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,166
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

When running the code, you can hover your mouse over the words in that line of code to see what their values are.
Look at the values of
.SourceFullName
OldPath
NewPath

Do they look correct to you?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 06-11-2024, 11:01 PM
AlexB84 AlexB84 is offline Relative Link from Excel to Word Link Field - Macro problems Windows 10 Relative Link from Excel to Word Link Field - Macro problems Office 2021
Novice
Relative Link from Excel to Word Link Field - Macro problems
 
Join Date: Jun 2024
Posts: 2
AlexB84 is on a distinguished road
Default

Yea they look correct.

But I think 2 things are not really working:
1. It seems like it only works when the Excel-File is in the same directory as the Word-File.
2. When copying the project to a new destination (directory), Word tells me (When running the macro), that it cannot open 2 Exel-Files with the same name at the same time.

I wonder if this code really works.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Link and Word Relative link. Dazwah Word 1 01-31-2024 12:56 PM
Word tables and excel paste link - problems with update link Trevor Word Tables 0 02-10-2023 02:07 AM
Relative Link from Excel to Word Link Field - Macro problems Word relative link to OLE objects from Excel Marcosnilsson Word VBA 4 01-19-2023 07:59 PM
@Macropod Macro VBA LINK Fields Relative Paste Special as Image from Excel word bug ggll Word 0 09-18-2021 11:48 PM
Relative Link from Excel to Word Link Field - Macro problems Word relative link to excel - How can you explain this ? SamVDS Word 6 04-10-2020 01:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:03 AM.


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