Hi,
I have been trying to change the icon of all sub folders (actually categorized depending on subject) of a main folder using excel vba. This shall help to make it possible to change the icon in one go, without consuming much time.
Data Available:
For this, i have an excel sheet, in which:
1. Column A, has got the path of all folders.
2. Column B, is with path names of all *.ico files.
What i am looking for:
1. Assign the icon to each folder having the path in column A, having the path of *.ico file in column B.
2. To symbolize this, a column C should have the image of the icon file.
3. Also if the folders categorized after this code, can also be arranged according to the New folder icon and then in Alphabetical order would impart another feature to the coding for its perfect use.
This is am seeking for the Folder list of around 500, so that is required to have more categorization apart from their names, which shall assist in recognizing it.
The similar request is also posted in http://www.mrexcel.com/forum/showthread.php?t=598133 .
This has been posted in this forum, and waiting for someone to get back for resolving the problem.
Hoping someone shall help me out in getting it solved.
Anticipatory thanks!
Bookmarks