Skipper 2004-11-16 11:12
Hello, I have to copy a lot from one Excel workbook to another. Problem with Excel is that new workbooks are opened in the same window, so you can only move the whole application with all the workbooks.
Do you know a solution to put a workbook on another screen ?
BR
|
Christian Studer 2004-11-17 02:17
To do this, maximize the main Excel window to the desktop, then restore the document window.
You can now move document windows freely within the main Excel workspace, and documents can be positioned on different monitors.
Christian Studer - www.realtimesoft.com
|
Craig 2005-01-07 05:17
Another approach is to launch another copy of Microsoft Excel.
I often times find this applicable, and quicker than the reccomendation given.
just a simple windowskey-r,excel away.. :)
- Craig
|
Christian Studer 2005-01-08 02:17
Thanks for the tip.
Do you know if it's also possible to have documents open in a new Excel instance by default?
Christian Studer - www.realtimesoft.com
|
Craig 2005-01-09 14:56
I'm not aware of a program setting that would allow you to do this. If you/anyone knows/figures out a way to do it... I'd be most interested. :)
- Craig
|
Sam 2005-01-18 00:59
Here's how I do it in WinXP:-
1. Make a shortcut to the excel file on the desktop or start menu.
2. Right click on the shortcut and select properties.
3. Click the Shortcut tab.
4. In the Target: field, insert the path to excel.exe before the path and filename that's already there. Yuo may need to use quotes. Here's what mine looks like:-
"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "T:\Server Storage\Central Store\Tech\Port Allocation.xls"
5. Click OK and you're done. The icon for the shortcut should have changed to the Excel program icon instead of the Excel workbook icon.
Hope that helps!
|
Craig 2005-01-20 11:34
Anything a little more dynamic?
i.e. I want to load another document in another window fairly quickly.. :)
- Craig
|
Shawn Bryant 2005-02-17 07:03
This should set Windows to open Excel documents in a new Excel instance by default:
From My Computer, select Tools > Folder Options > File Types
Under "Registered file types" find "XLS Microsoft Excel Worksheet" and click "Advanced".
Under "Actions" select "New..."
In the "New Action" window, enter the following:
Action: Open in New Instance of Excel
Application used...: "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e "%1"
(Make sure to include the quotes in the 'Application used...' section; edit path to excel.exe if necessary)
Click OK. Now select "Open in New Instance of Excel" and click "Set Default".
Now when you right-click on any XLS file, you will have the option to "Open" as well as "Open in New Instance of Excel", which will be the default (i.e. what happens when you double-click).
It seems to work fine for me...
Shawn
|
Ralph Purtcher 2005-04-13 23:10
If you have an instance of Excel (perhaps a hidden instance) that is not be used when the user opens a document from Windows Explorer (i.e. if you want a new instance of Excel to be opened for the new document), set the excel VBA property Application.IgnoreRemoteRequests = True. You can do this remotely using Automation.
|
Alex Galindo 2006-02-17 04:55
Thank you Shawn Bryant !!
I work with two monitors and "Open in new instance" is really helpful
Finally my search ended
Alex Galindo
Mexico
|
John 2007-11-28 10:15
Shawn,
You are truly a scholar and gentleman. I have wanted to be able to do this with excel forever!
|
