Outputting individual cells to individual text files

Hi,

Firstly, I'm not too good with VB programming (or even excel for that matter!), so perhaps my search terms weren't perfect, but I've looked high and low for a solution to this puzzle.

I'm convinced it can be done as I've seen people doing *similar* things (ie importing FROM multiple files into different cells/workbooks) but nothing that matched my requirements - and unfortunately I don't have the know-how to pick apart their code and make it work in the way I need it to.

Anyway, simply put, I have a bunch of data which makes up unique commands to run, so the files need to be individually named.

In the most simplistic form, I have:

A	B
1	command1
2	command2
3	command3
4	command4

I basically would like for instance a file to be created called 1.txt (or even .bat) which inside it contained Command1, then another called 2.txt with Command2 inside it

And so on!

Any pointers would be greatly appreciated

Hi Jerry

Thanks for your reply.

Please forgive my lack of knowledge here.

So I've opened up Developer > Visual Basic

I've gone to view code of the workbook, and have pasted in the code that you kindly sent to me.

I changed the path to "C:\New\" and changed Sheet1 to Sheet 5.

I ran it, and I'm getting an error 'Subscript out of range'.

As the data I want to write to the file is in column 'L', I tried altering the code from Range("A:A") to ("L:L").

The numbers of the files are in K, so I also tried ("K:L")

Where am I going wrong (probably at the start!)

Thanks again.

OK I've debugged it (thats a clever feature!), and it's stopping on the Set cmdRNG line (line 7)

The sheet in question has been renamed, it is called 'Server List'

In My VBAProject - the object tree shows:

Sheet5 (Server List)

I've therefore tried:
Set cmdRNG = Sheets("Sheet5")
Set cmdRNG = Sheets("Sheet5 (Server List)")
Set cmdRNG = Sheets("Sheet5(Server List)")

But with no luck. It is showing 'Run-time error '9': Subscript out of range'

In regards to your question - yes that is what I'm trying to achieve. I can then modify as needed from there using batch files.

Thanks

OK that seems to be better, I'm getting a different error

If I just run the code, it says 'No cells were found'

If I debug it, it stops on the same line - but it's showing Run-time error '1004'