Loop macro and open external programme

[ScabbyDog]

I have the following which opens notepad from excel

Please Login or Register  to view this content.

I also have this which pops up depending on set criteria.

Please Login or Register  to view this content.

How can I get macro2 to run, but instead of popping up in a message box, I want whatever would normally popup to be entered into notepad.

Possible? Any help would be fantastic!

[Chippy]

Change Run_Notepad as shown below and write data to a .txt file and call Run_Notepad similar to Macro2a.

Please Login or Register  to view this content.

[ScabbyDog]

That macro works fine for pulling whatever is currently in A1 and A2 but if you look at my loop code above I want it to write data to notepad based on what would popup in the macro2 I have above.

[Chippy]

My code was just an example to show the technique. I thought you would be able to adapt your code to work in a similar way, for example depending on how you want it to work you could replace the MsgBox line with the following 6 lines:

Please Login or Register  to view this content.

Or, if you want you put all values in one file and open that file in Notepad, put the Open, Close and Run_Notepad outside the loop. I'm sure you can work it out with the help I've given.

[ScabbyDog]

Yes I want all the data to be in one file that is opened in notepad. I'll give it a go later when i'm home. Thanks for your help so far! Much appreciated.

[ScabbyDog]

Ok, so I can get it to work fine but it opens multiple notepads. How can I get it all in one instance of notepad?

Please Login or Register  to view this content.

[ScabbyDog]

Ah I only noticed your comment saying put open.close/run outside the loop! Works perfect. Thanks!