VBA to move an excel file to another folder

[tvt]

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!

[Harald Staff]

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

"tvt" <[email protected]> skrev i melding
news:[email protected]...
> 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]

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

[tonywig]

Is it possible to select the name (and location) of the file from a value in a cell (or series of cells such as one for directory and one for file name)?
AND
Can I trigger an FTP of same file from Excel (using VBA I assume) specifying from and to locations based on values in cells?

[DUKE888]

Amazing handy code
Source: http://www.tek-tips.com

Please Login or Register  to view this content.