vba code question in excel to manipulate notepad document

See my post at MrExcel.

I'm looking at that link now trying to figure out what to add and where... Unfortunately I'm not very good with vba.. I'm trying to learn it though, but it seems at a snails pace. Thank you!

All you need to do is to copy what I posted and change the sub t(). Change the value of s to point to your txt file's name.
e.g.

Please Login or Register  to view this content.

Insert this and the other code into a Module. Name the sub t() whatever you like.

Well Ken I thought I did what you said, but apparently I'm still missing something... this is what I've done:

Please Login or Register  to view this content.

Ideally I want to save the document as "analysis.txt" and have it placed in the following directory c:\Analysis\ Thanks for your time & help!

You added your old routine which is not needed. Always avoid Sendkeys when you can.

You did not include the three routines that I posted. As stated in the MrExcel thread, you also need to add the Forms reference from the Tools > Reference, as commented in the getClipboard() sub.

The total solution would be:

Please Login or Register  to view this content.

I really appreciate your help!