Look up Name in VBA's help.

Or even FileCopy and Kill.

These options will work if that file (doesn't have to be an excel workbook)
isn't open.

tvt wrote:

Hello,

I want to write a macro that takes an existing excel file (workbook) and
place it in another folder. Basically something that would simulate cutting
a file from one folder and pasting it in another. Is this possible using
VBA? If it is, what would be the code or where can i find the code to do so?
Thanks!

--

Dave Peterson