Macro to Launch Notepad

**Andrew.Trevayne** · 08-17-2011, 04:19 AM

Hello!
I have some data on cells A1, A2, B1, B6, C3 and C5.
Could you help me with a Macro that when clicked it will launch Notepad with these Data in one same column?
Hope you could help. Thank you in advance.

**Chippy** · 08-17-2011, 05:05 AM

Create a file using Open and Write # statements, then call the Shell function to open it in Notepad.

**Andrew.Trevayne** · 08-17-2011, 05:14 AM

Hi Chippy, Im not really good in Macro. I did a search here on the forum and Ive seen a lot which saves and copy data on Notepad.
However what i was looking for is a Macro that will copy the data and then Open that Text file.
Thanks.

**royUK** · 08-17-2011, 08:14 AM

Try

Please Login or Register  to view this content.

**Andrew.Trevayne** · 08-17-2011, 09:35 PM

@royUK
Great Stuff! Thank you ^^

**hoongz** · 10-03-2011, 11:00 PM

Originally Posted by royUK

Try

Please Login or Register  to view this content.

Hi RoyUK,

Im experimenting with this function as well. Could you explain what does the Range("A1"), Range("A1").End(xlDown) refer to? Thanks a million