+ Reply to Thread
Results 1 to 6 of 6

Changing windows Folder icons usin vba

  1. #1
    Registered User
    Join Date
    05-27-2009
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    28

    Changing windows Folder icons usin vba

    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!

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Changing windows Folder icons usin vba

    Sanits591

    You would have to download a third part add-in
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    05-27-2009
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Changing windows Folder icons usin vba

    Thanks Pike! for responding to it.

    I am just trying to find a way out for this, as in one of the forum http://www.excelfox.com/forum/f12/cr...g-excel-vba-7/ , this was working, but it was used by picking the icon and folder to assign an icon to the folder.

    But i am trying to assign the different *.ico file to all different folders, as was discussed in the problem mentioned. I would be happy enough, if only the 1st problem, i.e. 1. Assign the icon to each folder having the path in column A, having the path of *.ico file in column B, is resolved.

    Request to have a re-look on this.

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Changing windows Folder icons usin vba

    Try this modification

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    05-27-2009
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Changing windows Folder icons usin vba

    Thanks for this! You have really made my day.

    i think instead of
    varFolder = xItem.Offset(1, 0).Value 'add this

    we can make use of
    varFolder = xItem.Offset(0, 1).Value 'add this

    Can we look for the 2nd question, can we drag the image of icon in the next column, i.e. "C"?

    Again Thanks a lot for it.
    Last edited by sanits591; 12-19-2011 at 06:40 AM. Reason: Slight change

  6. #6
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Changing windows Folder icons usin vba

    Thanks to Excel Fox

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1