move file

Hello Everyone, I am working on one big project and need your small help in the same. I want to move excel files to folder based on their file names. below is the example - I have a folder path in A1 - B1 have date : 20-07-2020 - C1 have date : 15-07-2020 in path i have four files: 1...

Hi Guys and Gals I have a problem that is out of my expertise I have some VBA working fine doing what it needs however the end goal is to copy a file form a network drive to a local drive, however, the local machine i need this on does have excel installed to fire the VBA form task scheduler...

Hi, I am using the below code in a large macro. I can't get it to work exactly. I am trying to have the old version of the file (which is the file being opened) moved from the current filepath to an archive folder. I would then save a new version of the folder in the current filepath. The...

Hi all. I have the following code. Sub MoveFile() Dim dFolderPath As String Dim dFilePath As String dFolderPath = Range("FolderPath").Value dFilePath = Range("FilePath").Value FileCopy "U:\CS Data\01 Live\2014-2015\Calendars\Cust Serv Calendar.lnk", "dFilePath" Shell...

Hello, I currently have an active workbook being saved (using VBA)to the desktop for easy access. I would like to create a macro that (on a command button) deletes/moves the active workbook from the desktop to a different folder (C:\Users\jjlafond\Documents\). I'm not at all sure how to go...

Hi All, I've come back with yet another problem. I know I can get the accurate answers here. I have resume file in PDF format placed on a shared drive on a network and it is assigned letter Z (Z:\). I access my path as Z:\WFM\Resumes. I have close to 60K resumes there. I have a link to each...