Solved

Open Excel 2000 files in new windows like Word 2000

Posted on 2002-04-10
4
301 Views
Last Modified: 2008-11-11
Hi

Does anyone know how I can open Excel (XLS) files in new Excel 2000 windows like Word 2000 (each Word (DOC) file is opened in a new window).

It is possible to start Excel from a DOS Prompt twice with different names, and then obtain two separate windows each containing one file - but this not an appropiate solution...

Regards,
Brian
0
Comment
Question by:Brian_HP
  • 2
4 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 6930651
In the VIEW options, the "windows in taskbar" will place a "window" for each file in the windows taskbar, but i guess that you want it even differently.

CHeers
0
 

Accepted Solution

by:
Dracos earned 50 total points
ID: 6942900
Hi.
You need to change the XLS files behavior.

Open My Computer.
If you have Windows 98, 95 go to View - Folder Options.
If you have any other OS, go to Tools - Folder Options.
Select the "File Types" tab.
Scroll down to the "XLS" extension and clikc on Advanced (or Edit).
Then you should see a check-box "Browse in same window". Make sure this check box isn't selected.
0
 

Author Comment

by:Brian_HP
ID: 6950307
Hi Dracos,

Your answer was not all I needed. Your solution only put each XLS file into the task bar, I wanted each XLS in different windows. But, your hint helped me to solved the problem properly, and therefore I'll give you the points anyway.

The right solutions is to do what you propose. After that, you will have to add a new action, e.g. called oooo, and copy the program execution line from Open into this and add ["%1"], i.e. ["...\Excel.exe" \e "%1"]. And finally, mark this new action as the default/standard. Solved!

BTW, do not propose answers, only comments! Comments can be turned into answers ....

Regards, Brian
0
 

Author Comment

by:Brian_HP
ID: 6950308
Hi Dracos,

Your answer was not all I needed. Your solution only put each XLS file into the task bar, I wanted each XLS in different windows. But, your hint helped me to solved the problem properly, and therefore I'll give you the points anyway.

The right solutions is to do what you propose. After that, you will have to add a new action, e.g. called oooo, and copy the program execution line from Open into this and add ["%1"], i.e. ["...\Excel.exe" \e "%1"]. And finally, mark this new action as the default/standard. Solved!

BTW, do not propose answers, only comments! Comments can be turned into answers ....

Regards, Brian
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question