[RESOLVED] want to create a txt file using content from excel

[cssriraman]

Hi all,

I have an excel file. It has some names in Cell A1 to A10 as follows:

          A 
1     app-01 
2     app-03 
3     app-05 
4     app-07 
5     app-09 
6     app-11 
7     app-13 
8     app-15 
9     app-17 
10   app-19

The user will select the cells A1 to A10 (or A1 to A5 as per users wish) and then, if we run a macro, the macro should create a text files from A1 to A10 (or as per users wish), like "app-01.txt", "app-03.txt", "app-05.txt" and so on in "C:\Temp\" folder.

Any Coding help pls!

Thanks,

CS.