VBA cannot find file in path

[kesss]

<tbody>
[TD="class: votecell"]

​

[/TD]
[TD="class: postcell"] Hi I am trying to copy a folder from and paste it into another folder which I have created on my desktop. The creation of the folder went succesfully but copying doesn't seem to work for some reason. It keep getting the error that the filename cannot be found although the pathname is correct. Thanks

[/TD]

</tbody>

Hi

I am trying to copy a folder from and paste it into another folder which I have created on my desktop. The creation of the folder went succesfully but copying doesn't seem to work for some reason. It keep getting the error that the filename cannot be found although the pathname is correct.
Can somebody help?


Sub UsingScriptingRunObjectLibrary()


Dim fso As Scripting.FileSystemObject
Dim NewFolderPath As String

NewFolderPath = "C:\Users\muhar\Desktop\fso"


Set fso = New Scripting.FileSystemObject

If Not fso.FolderExists(NewFolderPath) Then
fso.CreateFolder NewFolderPath
End If

fso.CopyFile Source:="C:\Users\muhar\Desktop\varia\Automation\VBA Script\Oefen_excel.xls", Destination:="C:\Users\muhar\Desktop\fso" & "\VBA"
Application.DisplayAlerts = True

End Sub

 

[davesexcel]

Is it possible you are missing the file name at the end?

Sub CopyToDifferentFolder()
    FileCopy "C:\Users\Dave\Downloads\SourceFolder\OriginalWorkbook.xlsm", _
             "C:\Users\Dave\Downloads\DestinationFolder\OriginalWorkbook.xlsm"
End Sub

http://www.xlorate.com/excel-questions.html#Copy Files to a different folder

 

[kesss]

Hi Dave

I have named the file 'Oefen_excel.xls' (practice excel in Dutch ) to keep it simple. It is a normal excel document.
For some reason vba keeps saying that the document can not be found although the pathname is correct.
I have created a folder with the following path name: "C:\Users\muhar\Desktop\fso" and this doesn't create an issue but "C:\Users\muhar\Desktop\varia\Automation\VBA Script\Oefen_excel.xls" above does.
Now I am kind of stuck....
thanks

 

[Dryver14]

Is the xls part correct? just wondering with the vba in the title

 

[kesss]

Hi

I have also tried without the xls extension but keep getting the same error.

 

[Dryver14]

It will require an extension, I was just curious if the file was an xlsx or xlsm extension

 

[Fluff]

Cross posted https://stackoverflow.com/questions/48764341/vba-cannot-find-file-in-path#

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[kesss]

Hi Dave

I tried with the xlsx extension and now it works!!!
Many thanks for this as I have lost a couple of hours trying other things to solve this.
You are great!