Re: Running Two Instance of Excel 2003 Simultaneously - Advice Ple

Tech-Archive recommends: Speed Up your PC by fixing your registry

Pretty soon you'll end up with a dozen EXCEL.EXE entries in the Task
Manager.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:h3jhr35bjdd58dliqoht4bd0idndpffqkt@xxxxxxxxxx
Jon's caveat about having multiple instances running is a good one.

Every time you open a new file from outside one of the instances, a new
instance
will start.

i.e. With Excel closed go to Windows Explorer and start double-clicking
excel
files to see what happens.

You may also notice that a double-click will open an instance of Excel but
no
workbook opens.


Gord

On Sun, 17 Feb 2008 15:54:00 -0800, Dermot
<Dermot@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

Thanks for the explantion Gord,

To Quote Jon in the previous posting........

Ignore Other Applications". Every time you double click an Excel workbook
in Windows Explorer, the workbook will open in a new instance. For this
reason I wouldn't recommend this technique, because you will have lost
control over when you get a new instance and over how many instances you
will have.

He wouldn't recomment this method......

What would your thoughts be on this?

Thanks in advance

"Gord Dibben" wrote:

1.. From Start>Run you are actually opening two seperate programs by
running
the excecutable file Excel.exe twice.

2. Go to Tools>Options>General and checkmark "Ignore other
applications"
When you double-click any *.xls you will get a new instance.


Gord Dibben MS Excel MVP


On Sun, 17 Feb 2008 01:20:01 -0800, Dermot
<Dermot@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

I am running Windows XP Pro

I have a two monitor installation arrangement configured to be
independant
screens to which I can drag window to one or the other.

I can open two separate instances of Excel 2003 Via Start | Run | and
entering "excel" for each instance of excel I would want to compare.

I have googled to find out if this is the correct and only way to run
two
instances of an application but the results are vague.

Question 1
Can anyone advise me how the method above works?

Question 2
What other methods can be used to achieve two instances of an
application
running.





.

Relevant Pages

  • Re: Check File Open Macro
    ... Dim oXL As Object 'This is needed to open a new instance of Excel. ... 'THIS LINE OF CODE OPENS THE NEW INSTANCE OF EXCEL. ... Internet, To Do Lists, Travel Tickets & Hotel Reservations and THE LIST ...
    (microsoft.public.excel.programming)
  • Re: Excel - Not calculating formulas
    ... Once calculation is set to automatic or manual (this mode is set by the first ... workbook you open in that session), then that calculation mode will stay this ... excel is still set in automatic mode. ... It takes the Option from the first file it opens. ...
    (microsoft.public.excel.misc)
  • Spreadsheet shortcuts not working
    ... We have shortcuts to spreadsheets setup but when we click on them excel comes ... up but the spreadsheet does not load and there are no error messages. ... But when the speadsheet opens it gives errors that it can not find ... Workstation O24 can not open excel spreadsheets using shortcuts. ...
    (microsoft.public.excel.setup)
  • Re: Code looping through files
    ... List box and I do have Microsoft Forms 2.0 Object Library installed ... Excel or from VBA? ... the References list box? ... in a folder, opens each, does things, closes the file and opens ...
    (microsoft.public.excel.programming)
  • Re: Code looping through files
    ... Any chance that Otto has access to that folder and you don't? ... detect and repair and as Chip has suggested I've looked in the References ... Excel or from VBA? ... in a folder, opens each, does things, closes the file and opens the ...
    (microsoft.public.excel.programming)