A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to open 2 excel instances by using XP schedule tasks?



 
 
Thread Tools Display Modes
  #1  
Old April 22nd, 2010, 09:24 AM posted to microsoft.public.excel.misc
Eric
external usenet poster
 
Posts: 1,956
Default How to open 2 excel instances by using XP schedule tasks?

I am using XP with SP3 and Excel 2003, when I setup a schedule task to open
file1.xls at 9 am, and open file2.xls at 9:15 am, does anyone know whether
schedule task will 2 excel instances or 1 excel instance?
Thanks in advance for any suggestions
Eric
  #2  
Old April 22nd, 2010, 10:08 AM posted to microsoft.public.excel.misc
Kevryl
external usenet poster
 
Posts: 119
Default How to open 2 excel instances by using XP schedule tasks?

Dunno....

But have you tried setting up a shedule to open file1 in 5 minutes from now
and file2 in, say 7 minutes?

There are, I think at least 3 ways that you can see how many instances you
are running:

1) I think its true in 2003 that when they are both open, if you look in
Windows/switch windows only the file running in that instance will show, in
which case you can ctrl-F6 between them. In other words, if two files are
open in 2 instances, you won't be able to ctrl-f6 between them.

2) Have a look in Task Manager- Applications tab which should tell you how
many instances are running.

3) If that isn't immediately clear, try closing Excel by clicking just once
on the red X close box - the "outer one" for Excel, not the "inner one" for
the actual file. If both files are closed by the one click, you had only one
instance running, but if one file remains open, you have closed one instance
and have one instance still open.

Hope I've hit the mark for you.

Cheers

"Eric" wrote:

I am using XP with SP3 and Excel 2003, when I setup a schedule task to open
file1.xls at 9 am, and open file2.xls at 9:15 am, does anyone know whether
schedule task will 2 excel instances or 1 excel instance?
Thanks in advance for any suggestions
Eric

  #3  
Old April 22nd, 2010, 01:00 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default How to open 2 excel instances by using XP schedule tasks?

I would guess that it would depend on what you use as the scheduler.

I use a program called Cron (or CronLite??). I could use that to start a .VBS
file that would create a new excel application each time it ran. (In fact, I
could use excel to start a new excel application to do the same thing.)

But I could also use my scheduling program to start an excel instance (separate
and hidden from any that the users are running), then start an excel file that
does the rest of the scheduling and that could use that same instance.

But I'm not sure what you're using and what you really want to do.

In case you want to read about scheduling programs using excel...

Chip Pearson's site explains it:
http://www.cpearson.com/excel/OnTime.aspx

Eric wrote:

I am using XP with SP3 and Excel 2003, when I setup a schedule task to open
file1.xls at 9 am, and open file2.xls at 9:15 am, does anyone know whether
schedule task will 2 excel instances or 1 excel instance?
Thanks in advance for any suggestions
Eric


--

Dave Peterson
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.