Error when trying to move a file via VBA

[cg0789]

Hello! I am trying to get a button on my spreadsheet which will move the workbook from a "In Progress" folder to a "Completed" folder, however when I run it, it says "File Not Found", but if I key in the workbook name instead of "ThisWorkbook.Name", it works fine. Any ideas on a work around? Or why its not working? Thanks in advance!

Please Login or Register  to view this content.

Solved! by Kelshaer - Thank you!!

Please Login or Register  to view this content.

(file is on a sharepoint)

[Kelshaer]

Try this

Please Login or Register  to view this content.

[Firefly2012]

Is the workbook you wish to move the currently open workbook (ie the one the code resides in)? If so, I would think you would get a File Access error rather than file not found unless you have written the path out wrong.

[cg0789]

Kelshaer:

That half-worked, and might be giving us some insight to what the problem is, now P:\ is a mapped network drive (I don't know whether that could be affecting this or not?), but now it errors out at "Kill OldFileName" at the end of the script which make me believe its a error deleting the file from a network drive, what is interesting, if I replace "OldFileName" with the exact file location, it works just fine. Any ideas?

Try this

Please Login or Register  to view this content.

[Kelshaer]

cg0789:
It doesnt matter if it is on a network drive.
About the line Kill OldFileName, this is very strange. I tried it on a network drive here and it worked perfectly. And if it works with the file name instead of the variable then please run the below macro and see the results
Please put the exact file location where indicated within the code

Please Login or Register  to view this content.

[snb]

Please Login or Register  to view this content.

[cg0789]

Ok, starting to make some more sense, ThisWorkbook.FullName is pulling the "exact location" of the file, which is on a SharePoint, not the P:\ directory which it is mapped to.

cg0789:
It doesnt matter if it is on a network drive.
About the line Kill OldFileName, this is very strange. I tried it on a network drive here and it worked perfectly. And if it works with the file name instead of the variable then please run the below macro and see the results
Please put the exact file location where indicated within the code

Please Login or Register  to view this content.

[Kelshaer]

Didnt Know it's on a share point.
Ok Use this. it should work

Please Login or Register  to view this content.

[snb]

Please do not quote (see the forum rules)

[cg0789]

That worked! Thank you!

[Kelshaer]

Does the code reside in the file that should be moved or not?
This macro assumes that the file containing it is the same file you are trying to move.