How to get some response from other applications

[Tzighan]

Hi there,
I am using Excel macros to provide some data to other application (SAP R3 window) using SendKeys and AppActivate funcionality.
I have two questions according to this :
1. How can I receive the names/titles of all currently opened windows/programs (bring them to the cells of excel sheet)? - as far as I know AppActivate works only in one way, but is there something what will give me an information about "what is opened" to use AppActivate after that using the names collected on the beggining?
2. How can I receive messages displayed in other applications (such as SAP)? - I have to have some feedback/response (place it to the cells of excel sheet) from application about some errors.

My English isn't well so I hope you understand what I'm talking about

Thanks in advance
Tzighan

 

[Derek Brown]

Hello and welcome to the Board.
I don't know the answers but have a look at Dynamic Data Exchange (DDE) - the following link may be of interest:
http://msdn.microsoft.com/en-us/library/aa211922(office.11).aspx
The topic is for Word but Excel will be very much the same.
Regarding the other question, if you have Visual Basic installed, have a look at the code available at:
http://www.freevbcode.com/ShowCode.Asp?ID=920
You may be able to adapt this for your needs.