copy files

Hi all, I have a code that moves a batch of files from one folder to another. my issue is when I try to change one of the locations to a cell reference, I end up with run time error 5. Any help with what is likely a simple oversight would be greatly appreciated! Sub Move_Aires() Dim FSO As...

Hi guys, I have a problem, I made a Sub function that copies files to multiple folder. its working fine except for one particular folder. I don't understand why it is keep copying 1 level below of target sub folder and the filename is changed to April - 1901-04-2019 <filename>.<ext>. All other...

Hello, I have 2 goals. 1) One macro to copy the most recent .xlsx files (based on saved date) from one directory to another, where I state the specific source and target paths 2) One macro that is similar to the one above, but allows me to state a saved date range in the code, find ALL .xlsx...

hi, i have found the below code in this link https://www.mrexcel.com/forum/excel-questions/982418-copy-multiple-extension-files-all-folders-subfolders-based-excel-sheet.html Sub CopyMacro()Set fs = CreateObject("Scripting.FileSystemObject")n = 2Do While Range("A" & n).Value <> ""fs.CopyFile...

Hi All, Is it possible to copy files with checkbox? I have a list of my pdf which are in a base folder. I have a macro which add checkbox to the rows and another macro creat a folder to the drive "C". I would like to copy into this folder on the drive C from the base folder the pdfs which I...

Hi everyone. I'm really new to this kind of stuff but mu boss has asked me to come up with something. I have a spreadsheet with file names in column A and either a "Y" or a "N" in column B. All the files that correspond to he file names are in folder "C:\copyfrom". If the value in column B is...

Can excel MACRO make copies of a file. I want to give path of one file and ask Excel to make copies of this file in same folders. Then rename these files.

Hi, I am trying to create a code that opens a particular folder and zip each file that is inside it. Then I want to copy each of these files to another folder. Lets say the first folder is C:\Old Folder And when all the files in this folder are zipped, I want to move it to a folder: J:\new...

I have a list of file names in excel. I know where all the files on the list are located (or should be located). Is there an easy macro that would read my list, copy the file from its location, paste it into a new common folder that contains only that files on my list. This does not have to...

I need to copy all files from one folder hierarchy to an other. An example: My source is in 'c:\1' which has a number of subfolders, some of which have subfolders, etc. Along the lines of: c:\1 c:\1\a c:\1\b c:\1\b\1 c:\1\c c:\1\c\1 ... All files have to be copied to 'c:\2' and go to the...

Hi, I am wondering if it is possible to program a VB macro that would open up a folder in a directory and open a Word file in that folder, copy the text and paste it back into an excel file, then close the Word document and open the next Word document, copy the text and paste the text in the...