rename file

  1. U

    VBA - Bulk Renaming of Files

    Hi Gurus, I'm currently working on a macro but can't find any that suits the process I have. I need to rename hundreds of files in word, excel and pdf format. Example Filenames: HOP12345 FileOne.doc 9876ABCD FileTwo 1234.xls A1RBL234 Data 000.pdf What I need is the macro that will rename...
  2. U

    VBA Rename File Names

    Hi Team, I was looking for some codes in bulk renaming of filenames and found below a helpful one (see current codes). I have a separate macro that can generate the file names (refer to B14). However, for me to change the filename, I do it manually. Example: Replace "." with "_Math_0619" and...
  3. U

    VBA Batch Renaming of Files

    Hi Excel Gurus, I'm looking for some post here regarding naming of files but can't find a suitable one. Basically I have these folders on my documents: Folder 1: Math Folder 2: Science Folder 3: History Inside the folders are different files like in the form of PDF, Excel, Text,jpg and Word...
  4. E

    Download Zip with new file name, auto open afterwards

    So I have spent WAY too much time trying to get to this answer. Below is what I need to get at...and yes, I have been to RondeBruin's site and it hasn't helped much from my limited knowledge. I have Excel 2010, WinZip16.0 (winzip64.exe), Internet Explorer 11 Download .zip file from site (I...
  5. K

    Rename the Excel Files using VBA Code

    Hi, I have more than 1000 excel files in a single folder and there are many folders like this. I need to write the code through which I can rename all the excel files of a Singhle folder can be renamed with the text present at "H2" in each excel file. Pls help me regarding the same...
  6. J

    Automatic picture naming

    Hello! I'm currently working on photoshoot and I got my customer database in excel. Is there anychance to either move files into certain folders based on customer ID (every customer has folder which is their ID), write some metadata into pictures as they arrive in one big folder (Metadata could...
  7. S

    Macro to rename files in a specific folder

    http://www.mrexcel.com/forum/excel-questions/421519-macro-rename-files.html#post3838597 Hello Everybody, I have following problem, discribed also in the link above. I need a vba code to - choose a folder instead of a file - find all the files in the chosen folder with name that starts...
  8. S

    Using the EURO symbol in filenames via an excel generated RENAME statement in a batch file ...!

    Hi Sorry if this has long since been discussed and solved, but sadly in searching this and other forums and the web, I can't find a solution! doh! Must be blind? I guess the fact I'm in the UK might be relevant to code pages etc. I'm reading in (well cut and pasting from a text file that is...
  9. N

    Extract parent folder name from file path

    i have inherited an access tool that imports a file into its database, makes a series of changes, then in its final stages exports the file back into the folder it originally came from with changes. this all works fine. however, what i want it to do, is export the file, but rename it to reflect...
  10. S

    VBA macro to rename a word file

    I have a file saved with a name. EX: Create Project Related Purchase Order, I need to change the name (as Create_Project_Related_Purchase_Order_QRG) with underscores after every word in the file name and _QRG at the end of the file. I want to use the VBA code to do this automatically in a...
  11. B

    VBA to normalize files in a folder

    First of all, thank you for all the support I got here during my previous question. I much appreciate it. I am still learning VBA, slowly getting the hang of it, but now I've ran across a complex problem which I have just no idea how to handle. Here is how it goes. I have my workbook stored...
  12. N

    Specific file rename macro

    Hi all, I need a macro to rename some files with specific names. I'll be very thankful if someone can help me, because I have to rename a lot of files every month. I have many files named like: John-2001021358-Company Name-June 2011-EX.xlsx Peter-2001522398-Company Name-June 2011-EX.xlsx ...
  13. T

    Problems saving file and retreiving file

    When I save an Excel file it often says that it cannot save and then renames the file and saves it under a new name with a strange icon that is white with three dots in it rather than the usual Excel icon. In addition when I open the file it frequently will not open properly only displaying...
  14. S

    Save .xlsm using PC name if file does not exist

    Hello All, This will be my 1st posting and I would greatly appreciate some advise on the best way to handle what I am attempting to accomplish. Basically, I would like to open an excel workbook file (.xlsm) and rename the file using the PC name ("Book1" & PC_Name). Obviously, I do not want...
  15. W

    Rename file based on cell

    Is it possible to create a macro to rename and save a file based on a cells content? For example, if the name in cell C2 is "John Doe" and D3 has the word "April", I want to rename the current file to John Doe and the current worksheet to April. Can you do this? Thanks in advance, Paul

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top