Object Links in Word

simogeo · #16 09-24-2015, 05:12 AM

macropod : I observed that the macro does not update automatically LINK when they are in Text Box. Is there a way to do so ?

(edit : Sorry, this is not the macro but Word itself which is not able to update the field in text box. Forget my question.)

Thanks

macropod · #17 09-24-2015, 06:27 AM

Try replacing your textboxes with single-cell tables. You can make those float on the page like textboxes but, because they remain part of the document layer, fields in them should update more readily.

simogeo · #18 09-24-2015, 06:36 AM

Quote:

Originally Posted by macropod

Try replacing your textboxes with single-cell tables. You can make those float on the page like textboxes but, because they remain part of the document layer, fields in them should update more readily.

Interesting ! Thanks

simogeo · #19 11-10-2015, 10:20 AM

Me again.

I'm working with Office 2010. When trying to applying your macro I get this error :

Quote:

a document with the name XXX is already open. You cannot open two documents with the same name, even if the documents are in diffferent folders.
To open the second document, either close the document that's currently open, or rename one of the documents.

and then a dialog box mentions a run-time error "6083"

Displaying the debugger highlight the following line :

Code:

.SourceFullName = Replace(.SourceFullName, OldPath, NewPath)

Any help would be welcome again.

I don't know whether it is important or not. I work with .xlsm and .docm files.

macropod · #20 11-10-2015, 02:08 PM

That suggests you still have links with the 'automatic update' property applied (aka the \a switch). Check each link under File>Edit Links to Files.

simogeo · #21 11-12-2015, 08:28 AM

Well, I did remove all \a updates but I still get the same error !

Another clue ? Thanks again

macropod · #22 11-12-2015, 01:32 PM

But did you check each link under File>Edit Links to Files?

You might also try the registry patch at: https://support.microsoft.com/en-us/kb/970154
For Office 2010 the key is at HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\W ord\Options

simogeo · #23 11-13-2015, 08:39 AM

I may try this. The problem is that I want to run this macro to deploy this on many computers I don't have control on.

So what if it works on mine but does not on others ? I'd prefer a generic and simple option.

I was also wandering if there was an other way to change links paths into a docx document like with executing a batch command line. Do you have any idea ?

I may also mention that the XLSX file is 40MB big. I don't know if it can explain the issue.

macropod · #24 11-13-2015, 01:47 PM

Quote:

Originally Posted by simogeo

I was also wandering if there was an other way to change links paths into a docx document like with executing a batch command line. Do you have any idea ?

That's what the macro does.

simogeo · #25 11-16-2015, 02:48 PM

Hi macropod,

Some news regarding my problem.
It seems that cutting-pasting the folder (containing bot WOrd and Excel files) is ok.
But copy-paste is triggering an error.

Looking at your code (I'm not a VBA guy as you already guessed ;-) ....) I wonder if modifying that part could help.

Code:

' Set the new path. 
' If your files are always in a folder whose path bracnhes off, one or more levels above the current 
' folder, replace the second '0' on the next line with the number of levels above the current folder. 
For i = 0 To UBound(Split(ActiveDocument.Path, "\")) - 0 
  Parent = Parent & Split(ActiveDocument.Path, "\")(i) & "\" 
Next i 
' If your files are in a Child folder below the (new) parent folder, add the Child folder's 
' path from the parent (minus the leading & trailing "\" path separators) on the next line. 
Child = "" 
NewPath = Parent & Child

Should I specify to the macro the level of the new path related to the old path ?
Could you give me a concrete example ? thanks

macropod · #26 11-16-2015, 02:51 PM

If both files are always in the same folder, there is no need to modify anything in that macro.

simogeo · #27 11-16-2015, 03:07 PM

Thanks for the quick answer
Could you confirm the bug when trying to copy-paste (in place of moving files) ?

macropod · #28 11-16-2015, 03:14 PM

I know of no such bug.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Links need to be Hot links in Bibliography in Word 2010, 2013	synses	Word	1	11-23-2013 12:48 AM
Linking an Excel object into Word	cncolom	Word	1	03-29-2013 03:01 PM
Problem: object library invalid or contains references to object definitions	aligahk06	Office	0	08-19-2010 12:29 PM
How to insert a project into Word as an object?	xxsawer	Project	0	04-11-2010 04:21 PM
Could not load this object as this object is not present in your computer	k.gaurav	Office	0	08-17-2009 09:57 PM