Solved Moving a file with click of a button

[donkey9972]

Ok, I have half of my problem solved, I just have no idea how to incorporate the 2nd half. So using a simpletext box, and button I can use the filedialog to select a file which I have done, How do I take that file location that is now appearing in the text box and move that file to a specific destination location? Note that the destination location will always be the same, so that can be put into the code or VBA without an issue. What is always changing is the location the file is coming from.

 

[CJ_London]

Look at using the filecopy function

FileCopy statement (VBA)

Office VBA reference topic

learn.microsoft.com

Followed by the kill statement

Kill statement (VBA)

Office VBA reference topic

learn.microsoft.com

 

[donkey9972]

I saw the filecopy but it requires a source file to be defined in the code. I am trying to find an option that takes the source file from whatever the user selects in the FileDialog method that appears in the textbox on the form.

 

[cheekybuddha]

You can use the VBA Name statement

eg.

Dim FileName As String
Const DESTINATION_PATH As Strin = "C:\Path\To\Move\File\"

If Len(Me.txtSelectedFilePath & vbNullString) > 0 Then
  ' Get file name
  FileName = Mid(Me.txtSelectedFilePath, InStrRev(Me.txtSelectedFilePath, "\") + 1)
  ' Do the move
  Name Me.txtSelectedFilePath As DESTINATION_PATH & FileName
End If

 

[donkey9972]

You can use the VBA Name statement

eg.

Dim FileName As String
Const DESTINATION_PATH As Strin = "C:\Path\To\Move\File\"

If Len(Me.txtSelectedFilePath & vbNullString) > 0 Then
  ' Get file name
  FileName = Mid(Me.txtSelectedFilePath, InStrRev(Me.txtSelectedFilePath, "\") + 1)
  ' Do the move
  Name Me.txtSelectedFilePath As DESTINATION_PATH & FileName
End If

Doesn't this still require the old file name to be put into the code? At least what I was reading in the link you provided that is what it seems to me.

 

[cheekybuddha]

So using a simpletext box, and button I can use the filedialog to select a file which I have done

Doesn't this still require the old file name to be put into the code?

Haven't you got the old filename in the textbox?

The code I posted (*should*) grabs the filename from the path/filename in the textbox.

 

[donkey9972]

I found my mistake on it. You are right, this does exactly as was needed. Thank you.

 

[cheekybuddha]

I found my mistake on it. You are right, this does exactly as was needed. Thank you.

Glad you got it working.

Did you understand what the code was doing?

If not, make sure to ask.

 

[donkey9972]

I had to look it over a few times, but eventually I understood this code. Thank you.

 

[moke123]

Personally I would use FSO as it has a move method as well as a copy method.

MoveFile method (Visual Basic for Applications)

Office VBA reference topic

learn.microsoft.com

 

[cheekybuddha]

Personally I would use FSO as it has a move method as well as a copy method.

MoveFile method (Visual Basic for Applications)

Office VBA reference topic

learn.microsoft.com

A lot of additional overhead just to move a file when there is a native built-in method, no?