Wrox Programmer Forums
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 12th, 2006, 11:21 AM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default Application Scheduling

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
 
Old January 12th, 2006, 11:27 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 100
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hiya Mike,

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

J
 
Old January 12th, 2006, 11:30 AM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

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
 
Old January 12th, 2006, 11:38 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 100
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old January 12th, 2006, 11:54 AM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts
Default

Thanks J!

That will definitely help matters. I appreciate it.

Mike

Mike
EchoVue.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
Scheduling a task eelisMX Pro VB.NET 2002/2003 5 April 29th, 2007 11:57 PM
Scheduling mwahab Excel VBA 0 February 23rd, 2007 02:24 PM
Scheduling database ... mnoon Access 2 January 31st, 2005 06:25 PM
scheduling reports barmanvarn BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 August 23rd, 2004 08:15 AM
Scheduling mrkyn Classic ASP Basics 4 December 1st, 2003 03:11 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.