Move and rename a file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter - 26 Jan 2007 12:24 GMT

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

Reply to this Message

Martin Fishlock - 26 Jan 2007 12:58 GMT

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.

Signature

Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.

> Calling all Excel programming brains,
>
[quoted text clipped - 3 lines]
> Thanks,
> Peter

Reply to this Message

Tom Ogilvy - 26 Jan 2007 16:13 GMT

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

Name oldpathname As newpathname

see VBA help on the Name STATEMENT.

Signature

Regards,
Tom Ogilvy

> Calling all Excel programming brains,
>
[quoted text clipped - 3 lines]
> Thanks,
> Peter

Reply to this Message