Excel Names in column to text files names to folder

Hello excel gurus,

I have a spreadsheet with names in column A, I need those names converted to text file names in a folder on the C:\ Annual report.
My excel VBA is only beginning to intermediate and this is beyond my skill set.
I would appreciate any help

Assumed :
this file : XLSForum-SaveFile.xlsm
on Sheet1 :
A1 : "Folder :"
A2 : "Name :"

B1 : you type complete path ( exp : C:\Annual Report\ )
B2 : you type name of file you want ( exp. year2013 )

Please Login or Register  to view this content.

*I use excel 2007

Oh, sorry to miss understanding.. I'll try to modify this VBA.. if this is not like your wish.. I'm sorry again..

First step : just highlights the name file on column A ( put the pointer on the cell contan the name file ) and then run this VBA

Please Login or Register  to view this content.

column A
1 Name1
2 Name2
3 Name3

In Folder C:\Annual Report\ Name1.txt, Name2.txt, Name3.txt

I select the names in column A then VBA code uses names in column A then saves names in folder as text files on C: drive

what file did you want to save as a text file? file that contain the name file on column A or another workbook?