Excel Macro Code Request for List files and Move specified directory

Dear all,

Please find below is my request to create macro code:

Step1: Browse Directory.
Step2: List files in above selected directory.
Step3: Create directory based on the file <Please do not use file extension and it contain same file name with different extension>
Step4: Move files based on its named directory.

Please help us to get this process solution.

Please let me know if you have any clarifications in this regard.

Thanks & Regards

Hi ganeshinscribe
There's probably much better ways of doing this but it sounded interesting.

1. Select a Folder and Click OK. The files in that Folder will be listed.
2. Select one (1) file of the file name you want to move (ignore the file extension...all files with the file name selected will be moved). Click Open.
3. Having selected one(1) file name, a new folder will be created with name of the file name selected in Step 2. This folder will be a sub folder of the Folder selected in Step 1
4. All the files with the selected file name are then moved to the new folder.

I don't have Excel 2003 but it should work in Excel 2002 and higher. I'd recommend you run the code on copies of your live file...just in case. Let me know of issues.

Please Login or Register  to view this content.

Hi ganeshinscribe
Reading your last post, it appears to me that you want 2 Buttons. The first Button to populate the worksheet with relevant information and to create the Directory. The second Button to do the actual move. Is my understanding correct?

Hi ganeshinscribe
Try the code in the attached. There are two Buttons:

1. Show Me: populates the sheet with the relevant data...it does NOT create the new folder. It simply tells you what it'll be named.
2. Move Me: creates the new folder and moves the files.

If you wish, this line of code in Show_Me can be changed to direct the User to their start folder

Please Login or Register  to view this content.

I've un-merged the cells in Column D...VBA doesn't like merged cells. Let me know of issues.

Hi ganeshinscribe
Well, you know, I now get the same error message. Seems, when I was cleaning up the code, I deleted a line that I shouldn't have...sorry about that. In Show_Me code, please insert this line

Please Login or Register  to view this content.

Let me know of issues.

Hi ganeshinscribe
In your screen shot I can't see what column A says. Make the column wider so I can see it.

Hi ganeshinscribe
I'd like to see your screen shot from Post #9 but with Column A widened so I can see what it says.

Hi ganeshinscribe
Never mind, I see what's happening. I'll need to look at it. I'll get back to you.

Hi ganeshinscribe
Well, we'll try once again. I believe this issue is resolved

but folder creating only administrator instead of file name

Regarding this

I want to run any directory instead of specified only "C:" is this possible

You can go to any directory you wish (up the Tree or down the Tree). If you don't want to start in C:\ simply change this line of code from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

In either case you can navigate up or down the Tree. Let me know of issues.