Export to txt

Hi there,

I am looking for a code that I can use to export a range of cells to a txt file, and place it on the desktop
I also want it to skip the rows where col D have "0"
The range is D9:M121
The file name must be the value from Cell E3

Thanks in advance,

Jakes

Hi David,

Thank you for the code , I just have one error, and it could be my fault. I have double checked the path, even set it to just C drive, but I keep get a error on this part:

Please Login or Register  to view this content.

My path is

Please Login or Register  to view this content.

The error message is:

Run-time error 75
Path/File access error

Ahh just a simple fault on my side. My apologies, and thanks for the help!

BTW how can I change the code so teh user can choose where to save the file?