VBA to move/make a copy of excel file.

Hello,

I just want to make a copy of an excel file and move it to another directory.
For example:

Source:

Please Login or Register  to view this content.

Move to:

Please Login or Register  to view this content.

Thanks in advance!

Use FileCopy

Hi Joakim,

thanks for the reply, could you please advise me a sample code?

Maybe:

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.