I have an app written in Excel that compares some files, produces necessary output and then closes. I would like to automate the running of this app. I have successfully scheduled it in Windows XP, but it requires me to click on the app when it first opens, and appear that it will only execute once it has the focus.

Has anyone done anything like this in the past and have any suggestions to make it run without any user intervention?

The other alternative is to create it in VB or something.

Thanks in advance,

Mike

Mike
EchoVue.com

__________________
Mike
EchoVue.com

Hiya Mike,

Have you checked out Excel's OnTime method???

J

I haven't...

My assumption would be that the application would have to running for an Excel method to fire - But generally my assumptions are way way off. How does it (The onTime function) work?

Thanks

Mike

Mike
EchoVue.com

Mike,

It probably isn't going to be any good for what you want as your Assumption is correct! The App has to be running, All the OnTime event does is run a specified macro/Routine at a specified time. You could you use both methods (Windows Scheduling together with onTime) to produce the result you are after. Use Scheduler to open the Excel App, then you could use the Ontime event to trigger your procedure. The onTime event doesnt need Excel to have 'Focus' in order to run resolving your Focus problem.

J

Thanks J!

That will definitely help matters. I appreciate it.

Mike

Mike
EchoVue.com