Excel cells to notepad

Hi

I am not sure whether this is feasible.

Is it possible 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.

Aries.png
In the sample attached, there will be 4 notepads generated (Aries.txt, Taurus.txt , Gemini.txt and Cancer.txt)

Aries.txt will have B2 and C2 contents
Taurus.txt will have B3 and C3 contents
Gemini.txt wil have B4 and C4 contents
Cancer.txt will have B5 and C5 contents.

Will appreciate if there is any macros that are able to perform the tasks.

Thank you very much for your time and effort.

Here, try this macro:

Please Login or Register  to view this content.

it uses sheet 2, A column to create data because I couldn't transfer enter (chr(10)). Probably there is a way but this is workaround.

Neil_ did it without helper column

Hi Neil_,

I was just wondering if the reverse process is possible ie copy from different notepads into excel cells?

Many Thanks

Becon

beconajoonu,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Hi Neil_

The code works fine! Thank you! On a side note, if I don't want the notepads to pop up, I can just delete this code "Shell "Notepad.exe " & sFileName, vbNormalFocus" right?

Hi zbor

I tried your code too! It works as well! However, there are 2 line spaces between B2 and C2. Nevertheless, thank you for the code.

Hi Neil_

Noted! Thank you so much once again!