move files

dear sir, i have a utility to move files from excel but this utility is not working for ".mp3" files. ".wav" are moving perfectly but ".mp3" files are not moving please help Sub MoveFiles() Dim i As Long, LastRow As Long LastRow = Range("A65536").End(xlUp).Row For i = 1 To LastRow Name...

Hi All. Any kind of help would be really appreciated. I have below VBA project which moves files from one folder to Master folder based on the specific identification number which is "T" and then numbers. For example. T98 Contract, T12984 Contract, T 92 Lease. below is the sample of file names...

I Have a condition where I need to check if a File contains a certain header. If the files does not contains the header "Ticket" then that file needs to be moved to a new Folder So it can be rechecked/Updated. I have most of the code written, just cannot put the finishing touches on it. Option...

Hi Folks, I have developed some VBA code to move files from a source destination to a target destination. For example: <tbody> Item Code (A1) File path (B1) AQU10000753.pdf S:\APS_Logistics\Images\PetsAtHome\03) EXTERNAL CODE IMAGES\HIGH RES - CONTAIN PRODUCTION MARKS!\NOT UPLOADED\...

hey all! I'm hoping for some help adding a line to this code I have. This current code moves a list of files from a main folder into separate folders that are determined by a spread sheet. so file 123ana will move into folder titled Ana because the list shows any file with ana goes into folder...

Hi folks! I've got a folder that has 5000+ pdf's in it. I've got a spreadsheet as shown below. I'd like to run a sub that copies the pdf's in the original folder and pastes them into the new folder.. Is anyone able to help? <tbody> PDF Name PDF Type Current Folder Copy to New Folder...

Hello all, I currently have multiple folders with PDF files in them, I have found and tweaked the following code to combine the PDF files within each folder into a single document (which is what I need it to do). However, what I can not figure out is how to add Bookmarks for each new file...

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...

Hi, I am getting a "Runtime Error 53 - File not Found" with the below code. I am trying to move xml files from one folder to another. The file exists as my other macro can access the xml files and extract the info. But i can't get the macro to move them! Any help would be much appreciated...

Hello, I'd like to know if there is any way to move a .wav file located in a local folder to another known local folder? I do not need to open the file. I'd like to use a variable for the name of the .wav file if possible. And I'd also like to use a variable for the pathname of both the...

I have a range of cells (a1:a2000), each of which contains a location of a unique computer file (c:\old folder\sample1.txt) that may or may not actually exist. I need to construct a macro that will ask Excel to search for the file listed in each cell and, if the file does exist, move it to...

Hi everyone, I use my Excel vba script to move files from one directory to other. When it comes across with filename that contains Chinese characters. A Run-time error 52: Bad file name or number will occur. I go to debug and found that the Chinese characters are read as ??? so it cannot...

I would like using VBA to move files from one folder to another. The files moved are time stamped greater than 48 hours old. Any help would be greatly appreciated. Thanks!