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.