MoveFile does not work when moving file in a variable 1

[mauricionava]

Hello, I have a form that first it gets the name of the file and stores it in a variable. When I try to do the fso.MoveFile (<souce folder> & <name of the file>),<destination folder> it does not work. If I say "\*.*" it will move all files in the source folder but I only want to move the one in the variable. How can I do that?

Thanks.

If fldr.files.count >= numberOfFiles Then
   
  For Each fil In fldr.files
  
  If Right(fil.ShortName, 3) = "TIF" Then
      If fil.DateLastModified < oldestDate Then
        oldestFile = fil.path
        oldestDate = fil.DateLastModified
      End If
  End If
  
  Next
  
  ShowFileList = oldestFile
   
  MsgBox oldestFile ' show me file name in a msgbox
  
  filename = oldestFile
  
  fso.MoveFile (sfolder & fso.GetFileName(oldestFile)), dfolder
End If

 

[ousoonerjoe]

Add the filename to the destination...

fso.MoveFile sfolder & fso.GetFileName(oldestFile), dfolder & fso.GetFileName(oldestFile)

"If I were to wake up with my head sewn to the carpet, I wouldn't be more surprised than I am right now.

 

[mauricionava]

Thank you very much! Works great.

 

[dilettante]

Is there a reason not to just use VB's [tt]Name[/tt] statement?

 

[mauricionava]

How does it work?

 

[dilettante]

Name Statement

 

[harebrain]

I just inherited a program that shells to a batch file to move files. I knew this was stupid, so I'll hang a star on dilettante's post for giving me another idea for improvement of this code.