VBA to move an excel file to another folder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Hi

It's very easy, given that the file and the to-folder already exist:

Sub MoveFile()
Name "C:\Temp\Book1.xls" As "C:\Junk\Book5.xls"
End Sub

HTH. Best wishes Harald
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Multiple CSV Files from Same Folder into Open Workbook 5
Import 4 Different Excel Files from One Folder 0
Move Workbooks With Certain Name? 4
Save file to same directory folder 2
Excel 2003 save as .XLSX 10
Maintaining hyperlinks when I move Excel files to another location 1
Copying macros to another workbook 2
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0

Back
Top