Printable View
I I look around a while ago and found nothing about it so I'm asking the mighty AO community.
When you open multiples Word Document, they all open in their own Microsoft Word Program (3 Word Document = 3 Winword process). In Excel, when you open multiple Excel file, they all open in the same Excel process (X Excel Document = 1 Excel process). Is their a way so each Excel file open is own Excel process?
Thank you! Good Answer = Full Pack of AP! ;)
Do you mean their own window? Are you trying to open them as a group or individually?
I almost want to say invest into Open Office which has everything as it's own process/window.
The best way to ensure that one open excel file == one open excel program would be to open excel three times, then to manually open the document from inside it (file, open, or drag/drop the document onto the open window).
SDK > My Word docs all run under 1 single process... If I open 10 Word docs, there's only 1 Winword.exe process, just like there's only 1 excel.exe process when I do the same with 10 Excel files...
If you open Excel from the command prompt, it does open 2 process/windows. But if you have Excel allready open and open another Excel file, it open in the same process/windows. I don't want that. I want to open in another process/windows.
Would this help: http://www.research.usf.edu/fast/How...y_to_Excel.doc
Quote:
Perform these steps in order to launch Excel files in a new window with full Excel functionality.
This setup only needs to be performed once.
Windows 98 (Windows 2000 and XP are further down in the document)
1. From your desktop, place your cursor over the Start button. Right-click on your mouse and select Explore. The Explorer window should appear. Select Tools - Folder Options.
2. The Folder Options window appears. Select File Types tab.
3. Scroll down and click on (highlight) Microsoft Excel Worksheet. Make sure you select the correct file type!
4. Once you've highlighted Microsoft Excel Worksheet, click on Edit button. The Edit File Type window appears.
5. Uncheck Browse in same window by clicking on the box next to it. This is how your window should appear before clicking OK.
6. Click OK to return to the Folder Options window. Select Close.
Your computer now launches Excel files in a separate window, containing all Excel functionality.
Windows 2000
1. From your desktop, place your cursor over the Start button. Right-click on your mouse and select Explore. The Explorer window should appear. Select Tools - Folder Options.
2. The Folder Options window appears. Select File Types tab.
3. Scroll down and click on (highlight) XLS Microsoft Excel Worksheet. Make sure you select the correct file extension!
4. Once you've highlighted XLS Microsoft Excel Worksheet, click on Advanced button. The Edit File Type window appears:
5. Uncheck Browse in same window by clicking on the box next to it. This is how your window should appear before clicking OK:
6. Click OK to return to the Folder Options window. Select Close.
Your computer now launches Excel files in a separate window, containing all Excel functionality.
Windows XP
1. From your desktop, place your cursor over the Start button. Right-click on your mouse and select Explore. The Explorer window should appear. Select Tools - Folder Options.
2. The Folder Options window appears. Select File Types tab.
3. Scroll down and click on (highlight) XLS Microsoft Excel Worksheet. Make sure you select the correct file extension!
4. Once you've highlighted XLS Microsoft Excel Worksheet, click on Advanced button. The Edit File Type window appears:
5. Uncheck Browse in same window by clicking on the box next to it. This is how your window should appear before clicking OK:
6. Click OK to return to the Folder Options window. Select Close.
Your computer now launches Excel files in a separate window, containing all Excel functionality.
Hi Simon,
If you open Excel again, THEN open the next spreadsheet you will get it running as a seperate task..........is that what you want to do? You need to open multiple excel sessions, not just double click on a spreadsheet. That just opens two sheets in the same session.
What you describe is by design, as Microsoft suspect that you might be using layered spreadsheets ( not just multiple pages) and want to move data quickly between them...........
This is a throw-back to Office 4.3, when you bought the modules seperately. I think that they were trying to promote Access :D
Bon chance! :)
EDIT:
You can do this by going into <start> <programs> and selecting Excel
If you open empty books they will be consecutively numbered:
Book1 = session 1
Book2 = session2
and so on.
What version of Office are you running Neg? I am running Office 2k and can reproduce his situation.Quote:
Originally posted here by Negative
SDK > My Word docs all run under 1 single process... If I open 10 Word docs, there's only 1 Winword.exe process, just like there's only 1 excel.exe process when I do the same with 10 Excel files...
Let me make a little change… When I talk about process and windows, it's not totally true. When I open winword by clicking on 3 different word documents, I get 3 windows. When I press Alt-F4 on any windows, only one windows close. When open 3 excels file, they open in 3 differents windows BUT when I press Alt-F4 on any of them, they all close and that annoy me to death!
Hi again Simon,
I just found out that english isn't your first language, so I'll try to explain a bit more fully. This will work for you.
Click on start, all programs, microsoft office, excel.
Do it again - as many times as you need excel documents open.
Open your files within the different excel windows by clicking file, then open, then browsing until you find the file you want.
When you close one, the rest will stay open.
Hope that helped!
|3lack|ce, I know it can be done this way. I want to do it the other day, by opening Excel directly by clicking on the file.
Ah, ok. Let me play with it a bit and I'll get back to you. I'm running office 2003 - and I have reproduced your problem.
[edit]I hope this solves it, although I'm bringing bad news. Hitting alt+f4 tells windows to close the entire program. It's the same thing as hitting the X-box at the top right corner. In Excel, when a new document (or book) is opened, it puts a smaller x-box in - kind of like the tab close x's in firefox. The smaller x closes the individual documents. The larger closes the program. The only way I can see to have alt+f4 only close an individual book would be to reprogram the alt+f4 hotkey through windows. Sorry I couldn't be of more help to you.[/edit]
[edit2] Found this which also might help
[/edit2]Quote:
Assign or change a keyboard accelerator
Show All
Hide All
You can rearrange and modify toolbar buttons, menus, and menu commands by using the mouse or you can use the Rearrange Commands dialog box which is accessible using a keyboard menu. These tasks are identified as (keyboard accessible).
A keyboard accelerator allows you to select a menu command or button by pressing ALT+<single letter>. For example, to open the Edit menu, press ALT+E.
[editfinal]And this, which judging by what I read, fixes your problem - (CTRL+F4)
I found that in the 'shortcut keys' helpfile under 'windows operations/windows interface' [/editfinal]Quote:
Close the selected workbook window.
CTRL+W or CTRL+F4
ok! Good Thank!
Just posting again to tag your email - please see my edit above. Still looking, but I think that's the only fix or it's not do-able.
Well, thank anyway! I'll stick to open excel by command prompt then! I pack AP to the thread for help!
I saw the ap assignment. Very much appreciated! Check the edits again - there's a solution there -
CTRL+F4
Thank. Sadly, I close all my windows using a hotkey (Alt-F4) that is programmed directly into a mouse button. And I really need to be able to open Excel twice to be able to have 2 excels file on my dual monitor (Doesn't work if it's the same workbook)