How to programatically embed an ICO File and a TXT file in same folder

Ok, Guys Here's what I need help with. I have an excel file that uses Chip Pearson's code to change the Icon. This File also creates its logs; hence a text file is also placed in the same folder. The first things I need help with: What I am thinking of doing is, On workbook close event, I want a Macro to embed those files into the workbook (Ico and txt file).


Secondly, When the workbook opens (Even if at a different location), The workbook places those embedded ico and txt files in the same folder so that they can be used for the purpose of changing the icon and also being the default log file

For the example: Workbook is Named: mywb.xlsm, icon file: TestIcon.ico, Log File: Mylogs.txt

Just to give an idea about embedding and exporting an ico file, you can use the procedures below...

This one will embed an ico file into the active sheet at range C10;

Please Login or Register  to view this content.

And, this one will extract the embedded file into the same folder with the Excel file;

Please Login or Register  to view this content.

You can ammend the codes to suit your needs ...