Creating external text file based on cell color

[snownut2]

I have work sheet that has a column of cells ("I") that can be 1 of three colors. (red, yellow, no color (white))

I would like to create two external txt files utilizing the contents of cell "a"& "text"* as the file name, if the color of the target cell is either yellow or red.

The txt files need to include the data from three cells in the same row as to colored cell.

I would like these txt files to include all instances of the particular cell color in the column "I".

I would like to print these two files (one for red, one for yellow), upon closing the workbook or exiting excel on Friday each week or if the workbook is not opened on a Friday then the next time it is opened.

This data could be appended to any per-existing txt file created previously.

I would also like to encorporate some header text in the txt file (new instance only), to be entered as hard-coded "text" in the VBA code. This text will not change each time, and should only be written if a file is created not appended.

Not sure if this is even possible, just giving it a long shot.

If anyone is up to the task it would be greatly appreciated.


Thanks,

Bruce

 

[snownut2]

I am sorry I made a mistake in the request.

The second sentance should be replaced with the following;

The filename should be the workbook name & "TEXT" that is hardcoded in the VBA, so it appears the same all the time.


Thanks again...

 

[snownut2]

I posted this yesterday an have had no responses yet. I do not mean to be pushy or sound indignant in any fashion. If anyone has any advice at all on this I would appreciate it, even if the advice is negative.


Thanks,


Bruce