Excel: change icon using VBA?

how to change the icon of a file (i.e a file has ABC extension, *.ABC) by using excel VBA?

I create a file with ABC extension, I want it to have a unique icon, how can I do that?Excel: change icon using VBA?
This is not controlled by Excel unfortunately it's controlled by the OS e.g. Windows. I'm going to assume your using windows for this.



You can set the icon and other preferences for existing and custom file types by doing the following:



1. Open Windows Explorer, or any folder on your computer.

2. Go to the tools menu, and select Folder Options.

3. Select the %26quot;File Types%26quot; tab.

4. Click the New button. Enter the extension type (e.g. ABC) then click OK.

5. It should now appear in the previous list. Select it and click the Advanced button.

6. Click the %26quot;Change Icon%26quot; button.

7. Select the icon required then click OK. Click OK again and close to finish.



Any files created as *.ABC will now have the icon you selected.



Cheers.