Renaming the files and exporting to a specified folder

**Peter987** · 11-09-2014, 05:58 AM

Hi All,

I work in back office team and I have to rename lot of files in a day and cut and paste them in relevant folders.
I know little about VB programming but I am not a Pro.

I need your help with a 2 part VB programming.

1st part :

The VBA macro/program should give me a option of inputting the location from where the macro/program will export all the files names and their types (e.g. xls, xlsx, doc, docx, jpeg, bmp, RAW, ppt, pptx, etc) to a excel sheet.

Eg.
If I store all the files (Excel, Images, Word docs, PPT, etc) in folder named "Week32" (Path: C:\Users\PeterW\Desktop\Week32\).
So irrespective of the VBA macro/program location, it should ask me location from where I need to import the names and file types of all the files.
I will put in (Path: C:\Users\PeterW\Desktop\Week32\) as input and run the above macro/program.
The program should generate a output with names and file types of all files stored in (Path: C:\Users\PeterW\Desktop\Week32\).

2nd part
I will copy the output from above macro/program and provide the relevant file namesand export destination against each of them.
Once I run the 2nd part of macro/program, it should rename the corresponding files and send them to specified folders.

Eg.

Untitled.png

PS: The file type should not change while giving a new name
Plz help !!!

**apo** · 11-09-2014, 06:29 AM

Hi..

So let me get this straight... you are going to manually enter the value sin the "New Name" column for each file?

Also.. Regarding the Destination Folder.. how do you want to enter that..? manually type it.. or.. probably something better imo like Browse dialogue opens on double click event of the cell in the "Destination folder" column..

The selection User makes would get inserted into the cell User double clicked on..

or.. if you only have a few different Folders you might choose form.. have Data Validation list dropdowns in that column..

**Peter987** · 11-09-2014, 07:17 AM

Originally Posted by apo

Hi..

So let me get this straight... you are going to manually enter the value sin the "New Name" column for each file?

Also.. Regarding the Destination Folder.. how do you want to enter that..? manually type it.. or.. probably something better imo like Browse dialogue opens on double click event of the cell in the "Destination folder" column..

The selection User makes would get inserted into the cell User double clicked on..

or.. if you only have a few different Folders you might choose form.. have Data Validation list dropdowns in that column..

Hi apo,

Yes, I will be entering the values manually in the "New name" Column for each file depending on their file type.

For destination folder, I will be entering it manually.