The simple answer to your question is that you need to write VBA code to do
what you describe. You'll want to consider things like identifying the
cell(s) you want to have involved in the process, whether the cell with the
filename will also provide the path, etc.




"BigIan" wrote:

Is it possible to make an external file from the contents of a cell? For
example if I have "Text acbd" as the contents of cell A1, can I write it to a
new file called Text1.txt?
If so, can the file name Text1.txt be in another cell, B1 for example?
So, I've got A1 = "Text abcd", B1 = Text1.txt, is there a command or VB
routine that I can use to make a file called Txt1.txt with the contents "Text
abcd"?

Thanks,
Ian