Thread: [Solved] VBA FileCopy Source: problem
View Single Post
 
Old 09-23-2014, 11:11 PM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
  
Join Date: Aug 2014
Posts: 4,137
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
The issue appears to be that you are running a macro from Word that will copy a normal template to Word which already has the normal template open. You cannot overwrite a file that is in use - and you certainly cannot run a macro from the normal template that, even if was possible, would replace itself.

The way to do this would be from a log-in script before Word is started, though frankly I would question the wisdom of it (other than for initial setup). The normal template is a personal user file. This type of over-arching central control, ruins productivity from your better Word users, and is completely unnecessary.

If you need particular conditions for documents then give the users document templates from which to create their company documents.

If you simply want to supply a set of macros, then supply them in the form of an add-in template - and again that would have to be copied using a log-in script.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote