Macro to Move files to the right folder

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Zan03

Thread Starter
Joined
Feb 11, 2010
Messages
7
Hi All,

I don't know if this is possible, or if there is a way to make this possible on a move forward basis, but I have to drop files into it's matching folder.

I have my folders set up as such:

Building Address -> Floor Number - > Unit Number.

Please see attached. If you click on building address "123 Test Company Street". You will find folder 1 appear. When you clean on each individual floor numbers, folder 2 will appear.

In my attachement, you'll find a bunch of PDF's. The first PDF is called "unit 102". I need that file to drop into folder into "FL 01"..."Unit 2".

The last pdf is called unit 308. I need that file to drop into folder "FL3"..."Unit 8".

Anyway i can write a macro which will place the correct file in the correct folder.

If it is not currently possible, any suggestions on how to rename my folders in order for a macro to work?

Thank you for your time.
 

Attachments

Joined
Sep 4, 2003
Messages
4,916
Yes it can be done. I'll try to take a look at it a little later when I have some free time.

Regards,
Rollin
 
Joined
Sep 4, 2003
Messages
4,916
Which application are you planning on running the macro from? You also have the option of using a stand alone VBS script but using a macro makes it much easier to debug and allows you more functionality. Can you also confirm that double digit floors will have a filename like "Unit XXXX" where the first two digits are the floor and the second two represent the unit?

Rollin
 

Zan03

Thread Starter
Joined
Feb 11, 2010
Messages
7
Thank you for your reply Rollin.

I haven’t decided which app I am going to use (I’m fairly new to this) but if you have a suggestion I’ll go ahead and get it.

Yes, double digit floors will have a filename similar to your example, where the first two digits are the floor and the second two represent the unit. As it stands, my folders are similar to my previous attachment, but I can rearrange my folders so that they are labeled by the full floor and unit number ex. inside the building address folder, you’ll find a bunch of folders labeled “Unit XXXX”.
 

Zan03

Thread Starter
Joined
Feb 11, 2010
Messages
7
Instead of a numerical floor number, we will have Unit "PHXX"

Penthouse2 would be "Unit PH02"

Thank you
 
Joined
Oct 9, 2007
Messages
15
I understand your need to keep organized using a folder system, but you may want trying to look into Evernote or MS OneNote to keep your reference material. It is a much more dynamic way to handle reference material using "tags" and search functions to find the files you need without the high maintenance issues you seem to be facing. The bottom line is finding what you need when you need it, quickly and easily right? Who cares how you go about doing it.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top