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