Export cell to txt file

Hi there, I am attempting to create a macro to create a txt file from a certain cell and save it based on a different cell. I am relatively new to VBA and I havn't been able to get it to work yet. Any help would be appreciated.

Dave

Dave

Some questions
1) What are the cells involved
2) What do they contain
3) Do you have a full path of the output file

How about an example file and some more step by step details on what you want to achieve.

rylo

I just need it to output the contents of any one cell.
It contains html that I have put together from several other cells using concatenate.
I also forgot to mention that it would be great if the path could also be based on another cell containing a path.

Thanks

Dave

Many ways do do it. Depends on if you want a one time write or an append.

Please Login or Register  to view this content.