Copy Excel data to Notepad file

Hello:

Please refer to attached file.
I need VB code to copy data from column D into txt file.
I have txt file for each store (ColumnA) and the name of the txt file for each store is StoreName.txt
For Example :
Store Name : Fayetteville has a txt file as Fayetteville.txt
Store Name : Riverdale has a txt file as Riverdale.txt
Store Name : SF0003 has a txt file as SF0003.txt
and so on

All these files are in location C:\Temp\Stores\

So basically
Fayetteville.txt should have 1 in the file
Riverdale.txt should have 0 in the file and so on for other store.

Note : Data will be in from A2 down to A12
Let me know if you have any questions.
Thanks.

Riz

Hi JB:

Works great...need liitle help further.
My actual data starts as follows:

Store Name : AE4:AE8 and other (0 or 1 data) starts at AH4:AH8

Would appreciate if you can help modify the code to accomodate for this data.
Thanks a lot

Riz

Hi Guys:

Superb help from both.
Thanks a lot..

Riz