Toggle between two excel applications

[timfran87]

I have a macro that cycles every 5 minutes. I have tried everything I can to get this program to run while I modify a sheet in the workbook to no avail. I have however figured out that if I open up a seperate excel application that my macro can continuosly run without preventing me from modifying the other application. Now I need to figure out a way toggle between the two excel application windows if a condition is met. The basis of this is to allow production associates to create a schedule and modify it while a macro looks into the defect database and if a defect becomes too problematic, the macro interupts the schedule to display the issue. Does anyone have any ideas?

 

[ChrisM]

I would set your macro in the defect database to run and save the database as often as necessary, every minute or whatever.

Then in your scheduling file, use MS Query to pull in the data from the defect database into a table. Edit the connection properties to automatically refresh every 5 minutes.

 

[timfran87]

I would prefer to do this, but the company that I work for has multiple locations adding to this database so they will not give me access to it. The only way I can look at the data is through an IE intranet search program that pulls up a summary of data specific to my location. I am looking for a setfocus type command to just identify and bring the other application to the front. I even tried Application.SendKeys "%{Tab}", True but that didnt work. I wasnt too heartbroken though because I am not a big fan of sendkeys. Any other suggestions.