Excel cells to notepad (2)

Hi everybody

Basically I want to copy the contents in cells B2 and C2 and paste them into a notepad (.txt) automatically with A2 as the title? And the notepads can be found in the same folder as the excel sheet.

Neil_ has kindly provided a code that works perfectly.

Please Login or Register  to view this content.

If the contents in cell B2 and C2 have line breaks, is it possible to edit/change the macro so that it can copy the contents (same format) and paste into notepad as shown below.

Excel.PNG Aries.PNG

Thank you for reading this and will appreciate if someone will be able to assist.

Thanks and warmest regards,
fantasylo

Of course Notepad is only useful if you just want to open the file after each one is created. I guess you mean get the path from the activeworkbook or thiswookbook as sheets have no path. Then all you needed is Replace().
e.g.

Please Login or Register  to view this content.

Hi Kenneth and AlphaFrog

I had tried the codes and it works!!!

Thank you so much for your time and help!

Have a nice day!