rename file vba

Hi All, First post! :) My question is (hopefully) very simple: I need a piece of code to add a new folder if the folder doesn't already exist. I have a working code that renames folders that appear is column A to their new name in column E (I pulled from the internet). I want to simply add...

Hi Gurus, Hope all is well. Is it possible to rename a file based on it's equivalent cell value and criteria? Scenario: I have different multiple files in a folder and in different file format Sample filenames in a folder 0001 Datasheetxx.pdf Dataaaaaasheetxx_002T.xlsx...

Dear Sirs, Can any one help me with writing a VBA the code, I need to rename all files & Documents inside the sub folders a with serial Text - numbers, Example : Inside the Admin Letter folder there is three documents (Scan 15, Scan 16, ID) I need the code to rename all these documents as this...

In my personal documents I'm using a sort of Naming Convention where all my files are named as follows yyyy-mm-dd-FileName.xyz The first characters refer to the Last Modified Date that in many cases represent the Creation Date of the file. ".xyz" I don't change it because it is the file...

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

I need to change how some code looks up a certain directory, previously I had it static where it was just a set folder. However now I want to make it a cell reference on a workbook im just not sure how to do so. Below is what I have, I would like it so its refering to cell A2 on a tab called...

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

Hello everyone, this is my first post on here and I'm totally new to Word, Macros, and Visual Basic programming, so apologies if I don't know the lingo, or if you spot me doing anything completely noobish. I do however have some experience with PHP programming and have spotted a few...

I have two scenarios where I need to rename an existing filename to append that file's last modified date/time to the end of the file. The most recently saved file needs to retain the original filename without a date.Directory: C:\temp Existing Filename: FileName.csv File's last Mod Date/Time...

I have successfully created a macro that upon clicking a submit button the excel file attaches to an email. It includes the To: email address and subject name based on cell content. I can not figure out how to also change the name of the file upon attaching. Sub Submit() Dim OutApp As Object...