Calling all Excel programming brains,

I am trying to move and rename a file but don't know where to start,
can anybody help?

Thanks,
Peter

There are at least two direct methods for copying a file:

FileCopy SourceFile, DestinationFile

CopyFile Method

Have a look at both and try them out.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Peter" wrote:

Calling all Excel programming brains,

I am trying to move and rename a file but don't know where to start,
can anybody help?

Thanks,
Peter

name "C:\Myfolder1\Myfile1.xls" as "C:\Myfolder2\Sub1\Report1.xls"

Name oldpathname As newpathname

see VBA help on the Name STATEMENT.


--
Regards,
Tom Ogilvy


"Peter" wrote:

Calling all Excel programming brains,

I am trying to move and rename a file but don't know where to start,
can anybody help?

Thanks,
Peter