![]() |
|
#1
|
|||
|
|||
![]()
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 ![]() |
#2
|
||||
|
||||
![]()
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 |
#3
|
|||
|
|||
![]()
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. |
![]() |
|
![]() |
||||
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 |
![]() |
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 |
![]() |
SamVDS | Word | 6 | 04-10-2020 01:41 AM |