Wait for beep

**peerogel** · 01-07-2013, 09:02 PM

I have an excel time sheet and I want to transfer the info to another software. I have managed to get the software to open; however, to login I have an application.wait (time) set up. The problem is that I keep having to change the wait time depending on the computer. Once the software (program) loads up, it always emits the beep sound.

same beep as:

Please Login or Register  to view this content.

I was wondering if it was possible to make excel wait for the beep of the other program before continuing with my login? Not sure if it makes sense, but something like this.

Please Login or Register  to view this content.

Thanks

**abousetta** · 01-07-2013, 09:11 PM

I've never tried that, but an easy workaround is that your program creates a simple text empty text file and let's say it will name it as 'beep.txt'. Excel keeps looping until it finds 'beep.txt'. Once it finds it, it deletes it and continues with the vba application.

Hope this helps.

abousetta

**abousetta** · 01-07-2013, 09:25 PM

I found this worked example online (http://www.makeuseof.com/tag/monitor...-slick-script/) that might help.

abousetta

**peerogel** · 01-07-2013, 10:17 PM

Thanks for the reply. I am a total noob and will give it a shot. Hopefully I can make it work.

**peerogel** · 01-10-2013, 02:20 PM

I just cant figure it out. I tried looking for a file that the application would make on startup but I cant find anything.

**abousetta** · 01-10-2013, 03:06 PM

Hi,

OK, I was assuming that you wrote the code for the 'other program'. If not then I'm not sure what the next step would be. Maybe if there was something in the Windows API that was triggered by sound or can capture sound then we may be able to tap into that, but I honestly have no idea how to proceed in capturing a sound created by another program. I'm not saying that it can't be done, but how is out of league.

Sorry I couldn't be of more help.

abousetta

**peerogel** · 01-10-2013, 03:09 PM

No problem, I appreciate the help.

**OllieB** · 01-10-2013, 03:17 PM

Is the "other" application a browser based solution, or a program like Word or something else? How did you manage to start it?

**peerogel** · 01-22-2013, 01:57 PM

Sorry, I didnt notice the reply. It is a Java based application. The only way i got the application to open was with prompt command. Cant really post the name, however i found a vba that gives you a pop-up if the a application you want open is not open... I played with it and i know it is totally wrong but this is what I did.

Please Login or Register  to view this content.

I want the vba to wait until the program finishes loading. Sometimes the programs takes to long and I get a timeout from excel. IOU is just a series of Sendkeys. This has been the only way i have managed to make the vba code wait and look for the program. Im still trying to figure out a better way.