Arrange or group folders based on the assigned icons to Folders using vba

RoryA

MrExcel MVP, Moderator

Joined

May 2, 2008

Messages

42,291

Office Version

1. 365
2. 2016

Platform

1. Windows
2. MacOS

• Dec 20, 2011

• #2

Arrange them in which window? Excel or Explorer?

 

Upvote 0

S

sanits591

Active Member

Joined

May 30, 2010

Messages

253

• Dec 20, 2011

• #3

Thanks for responding! I wanted to have the VBA code in excel with the path of folders with assigned icons in one column, that would be required to be arranged in explorer window.

Request to help me on this.

 

Upvote 0

RoryA

MrExcel MVP, Moderator

Joined

May 2, 2008

Messages

42,291

Office Version

1. 365
2. 2016

Platform

1. Windows
2. MacOS

• Dec 20, 2011

• #4

I do not believe you can arrange the explorer window purely by icon.

 

Upvote 0

S

sanits591

Active Member

Joined

May 30, 2010

Messages

253

• Dec 20, 2011

• #5

Can we assign any other attribute to the folder? In this case, the name of the *ico file to the folder attribute with which it can be arranged or grouped by that particular attribute.

This attribute, i.e. name of the *.ico file is also present in col B of the excel sheet.

Hope this may be resolved so that it makes it easier to reach our final objective.

Thanks!

 

Upvote 0

RoryA

MrExcel MVP, Moderator

Joined

May 2, 2008

Messages

42,291

Office Version

1. 365
2. 2016

Platform

1. Windows
2. MacOS

• Dec 20, 2011

• #6

It would be much simpler if you used a naming scheme, or actual folder hierarchy instead.

 

Upvote 0

S

sanits591

Active Member

Joined

May 30, 2010

Messages

253

• Dec 20, 2011

• #7

May i request to elaborate a little further, if it is been proposed like:

%group\%yyyy\%B\[%yyyy-%mm-%dd] %project\%type
%group - Image Group ("Scans", "Photos", "For Prints", or "For Web")
%yyyy - year Image creation, as four digits
%B - full month name
%mm - month as two digits (01..12)
%dd - day of the month (01..31)
%project - event name
%type - image type ("RAW", "VIDEO" or "")

Probably this may not be in line with what has been done in assigning the icons to folders, and would void the very purpose of assigning the icons to folders.

Kindly suggest.

Thanks!

 

Last edited: Dec 20, 2011

Upvote 0

RoryA

MrExcel MVP, Moderator

Joined

May 2, 2008

Messages

42,291

Office Version

1. 365
2. 2016

Platform

1. Windows
2. MacOS

• Dec 20, 2011

• #8

Yes that is basically what I am suggesting.
Since I don't know why you are trying to do what you are doing, I can't really comment on that, but you do appear to be making life hard for yourself.

 

Upvote 0

S

sanits591

Active Member

Joined

May 30, 2010

Messages

253

• Dec 20, 2011

• #9

I have another Q, can we assign the group to folders from excel VBA (as the number of folders are very huge) that is to say:
Col A - Folder Path
Col B - Name of the group to be assigned to folder

I think this can be arranged in the explorer window with the groups assigned.

Can we make it possible?

Thanks! for replying and investing your time.

 

Upvote 0

RoryA

MrExcel MVP, Moderator

Joined

May 2, 2008

Messages

42,291

Office Version

1. 365
2. 2016

Platform

1. Windows
2. MacOS

• Dec 20, 2011

• #10

I am not really sure of the logic behind the revised name, but renaming folders is a simple one liner:

Code:

name old_folder_path as new_folder_path

 

Upvote 0