rename files

Hi Guys Could you please assist me I have a master workbook that needs to be copied 500 times with different file names based on a list. I have used the following code Sub CopyAndRenameFiles_3() ' Define variables Dim MasterFilePath As String Dim NewFilePath As String Dim...

I am having trouble getting the correct "On Error" statement in my VBA code. I use a macro to list the file path in column A and copy and paste into column B and rename the files. If i list a file in column A that doesn't exist i want the code to continue onto the next file name in column A. As...

Hey guys. I've done some snooping around to find the solution to my particular problem, but don't know enough about using VBA outside of Excel to figure it out with what I've found. Here's what I want to happen: I want all files with the extension .pdf, .doc, .zip, and .7z to be copied from a...

Hi Guys, I need some help with the VBA code for excel 2010 to achieve the following processes: Grab the csv filenames from C:\TEMP\ Place filenames in column 1 rename files to xls format in C:\TEMP\ based on data in column 2 then Format the renamed files: Convert column A to whole numbers Sum...

Hello, I'm working on a project that requires me working with files and directories. I haven't had any issues yet with setting up user forms, letting users set file paths to folders or even selecting and importing files, etc... but I'm not sure how to grab all the files in a particular folder...

I have a script that looks at Column A for the old file name and compares it to a bunch of images in a folder, when it finds a match it then looks in Column B for the new file name and renames the files.. That works great except when the new file name is the same as the current and it generates...

greetings, as the title says, i'm trying to rename all files from a base path and files from its subfolders. my code, so far,.. only renames files in the base folder.. and it has an error path/file access error... Public Sub rFiles()Dim strPath As String Dim lngCount As Long Dim position As...

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.

Good morning all, I've been googling around to piece together a macro for uniformly re-naming files in Windows, but the methods I've found all seem to be different (and also don't do exactly what I need). In short, I've got several directories containing a lot of pdf files. These files need...

I have 400ish departmental budget files in a folder that I need to upload to a Sharepoint doc library. The files in the folder will have to exactly match the files we already have set up in sharepoint in order to upload them to the sharepoint site. As it stands now there is only one...