Sub MACRO()
Set FSO=CreateObject("scripting.filesystemobject")
FSO.MoveFile Source:="C:\Users\WolfieeeStyle\Desktop\Files\1.xlsb", Destination:="C:\Users\WolfieeeStyle\Desktop\"
FSO.MoveFile Source:="C:\Users\WolfieeeStyle\Desktop\Files\2.xlsx", Destination:="C:\Users\WolfieeeStyle\Desktop\"
End SubHere
i have posted my code which can do the process, only one thing is pending in this code
Add something that cant create a msg that this file is not located or moved when it is not present
When i run this macro and files are present then the files have been moved as per macro- It's good and i need that only
But when files are not located in that place and i ran the macro this gives an error msg that files is not present or its have been moved- I have no issues that files are not present ,if files are not present then do nothing no error msg should come (i need this in the code)