将文件从一个文件夹移动到另一个文件夹 [英] move files from one folder to another

问题描述

实际上，我正在搜索将excel文件从一个文件夹移动到另一个文件夹的代码(如果有办法的话)，请有人帮我.非常抱歉，但是我不知道如何编码，因为我从未使用过VBA，实际上我是第一次看到它.

actually I am searching for code to move excel files from one folder to another if there is any way to do so Please someone help me. I am very sorry but I dont know how to do coding as I have never used VBA in fact I see it for the first time.

我将感谢您

推荐答案

Sub MoveFiles()
    Dim FSO As Object
    Dim SourceFileName As String, DestinFileName As String

    Set FSO = CreateObject("Scripting.Filesystemobject")
    SourceFileName = "C:\Users\Jun.xlsx"
    DestinFileName = "C:\Users\Desktop\Jun.xlsx"

    FSO.MoveFile Source:=SourceFileName, Destination:=DestinFileName

    MsgBox (SourceFileName + " Moved to " + DestinFileName)
End Sub

这篇关于将文件从一个文件夹移动到另一个文件夹的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！