Get excel 2007 show results in notepad through VBA code

Hi all,

I´m about to go further with my OUCH message protocol converter in Excel 2007.

At the moment i have managed to create a sheet when i can enter OUCH message or up to 3 of them, depending on the message type it will be forwarded to correct sheet and appears in readable view.

1. First i paste 2 OUCH messages from TCP capture file (TCP sniffer) to cell B1 and B2 or just in B1.
INBOUND messages starts always with 1 character which is message type. OUTBOUND message starts with Time stamp and next character is message type.

2. If first character is O, the message will be forwarded to worksheet called Message type O or Q. I will also be automatically moved from OUCH Entry sheet to that worksheet.

3. Now i want the results to show up in Notepad instead. How is that done? Is it possible to use VBA code to bring up notepad and have the results shown there?

The problem is that if i have two different message types, the results will appear in 2 different worksheet. And that maybe causes some troubles how the data will be written to a text file or show up in Notepad.

Any idea how i can make this to work? Should i maybe create only 2 worksheets (one with OUCH Entry and the other sheet contains all message types and then get the results to show up in Notepad)

appreciate all help i can get, thanks. (I will add the OUCH converter so you can take a look if you want)

Thanks pike. Just need to rewrite the whole converter. since the data gets overwritten when all worksheets writes to the text file at the same time. Need to put all sheets together.

Thanks again, i figure it out.