You could use SaveCopyAs

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"DS" wrote in message
...
Peter81 - thanks very much for this post. For some time, when users are
submitting information on a form, I've been using the "SaveAs" command to
save a copy of the completed pro forma in a separate folder. This, of
course,
leaves the user in the "Saved As" copy following this, rather than in the
template, which means they have to close the open document, and reopen the
template in order to submit another. Using this FileCopy method will make
their lives (and therefore mine!) much, much easier.

Many Thanks for that!
DS

"Peter81" wrote:


I dont think there is an explict Move statement in vb so I think you
would need to use something like:

FileCopy(Source As String, Destination As String)
then
Kill(Source As String)

e.g
FileCopy "d:\games\darts.xls", "c:\games\darts.xls"

Kill "d:\games\darts.xls"

Pete


--
Peter81
------------------------------------------------------------------------
Peter81's Profile:
http://www.excelforum.com/member.php...o&userid=25353
View this thread:
http://www.excelforum.com/showthread...hreadid=532626