Create txt file from excel sheet

I am a beginner in excel macro, and hope to find an answer to my question in this great forum.
I want to create APRIL.txt file from the data in my spreadsheet.

The sample Sheet is attached here with.

If I may ask, what is the complication about this? I mean, if it's me I would just copy that and paste into a notepad and save.

This question's been asked a few times recently - so I've written a quick post to cover it:

http://excel.solutions/2014/04/using...-to-text-file/

yaa, it s work,

Thanks a lot all above my welwisher,

Hi apo,
will u add code if any row in a column A is mark "X" can skip in above code?

You can easily adapt my code to do that - see highlights in red:

Please Login or Register  to view this content.

Hi olly,

Thanks for prompt reply,
its work fine,

Hi, apo
u r right my data is in 1 column only and its "B" column,
above code is not working.

hi olly,
your code is perfect but its generate all column while i want only column "B" data only

Originally Posted by hkbhansali

hi olly,
your code is perfect but its generate all column while i want only column "B" data only

Come on, you need to start understanding and tweaking the code to suit your workbook.

Change the line highlighted in blue, to the range you actually want this to apply to:

Please Login or Register  to view this content.

So in your case, you may change this to something like:

Please Login or Register  to view this content.

Hi,olly, & apo
THANKS,
my problem solved, thanks for kind help.

Hi,olly, & apo
THANKS,
my problem solved, thanks for kind help.