Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to open a workbook into a new Excel application
Hi,
I'm wondering if there a way to open a workbook into a new application by default. So, when you double-click the excel workbook, it will start in a new Excel application. I think about something in the Open event but I don't know how to cancel the process and restart it into an other application. Thank you! Alex -- Alex St-Pierre |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to open a workbook into a new Excel application
Alex,
Excel is an application. Normally Excel runs with only a single instance of itself. You can do OLE linking with programs like MS Word. This sort of runs Excel inside Word. I have seen multiple instances of Excel running at the same time on one machine. Here the normal instance was started by either double clicking the file or the Excel icon. The next instance was started from a command window. So I'm not to sure what you mean by opening a workbook in a new application. Dennis "Alex St-Pierre" wrote in message ... Hi, I'm wondering if there a way to open a workbook into a new application by default. So, when you double-click the excel workbook, it will start in a new Excel application. I think about something in the Open event but I don't know how to cancel the process and restart it into an other application. Thank you! Alex -- Alex St-Pierre |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to open a workbook into a new Excel application
The reason why I want to start a workbook into a new Excel.Application is
that each workbook have their own menu (command bar control in addition to Excel menu ..File, Edit, Tools, ...) So, if I switch from one workbook to another, I have to delete the menu and create the menu into the workbook #2. It can be the same menu or not. I would have to have a menu bar that is unique for each workbook. Is there a way to do that? Thank you! Alex -- Alex St-Pierre "Dennis Tucker" wrote: Alex, Excel is an application. Normally Excel runs with only a single instance of itself. You can do OLE linking with programs like MS Word. This sort of runs Excel inside Word. I have seen multiple instances of Excel running at the same time on one machine. Here the normal instance was started by either double clicking the file or the Excel icon. The next instance was started from a command window. So I'm not to sure what you mean by opening a workbook in a new application. Dennis "Alex St-Pierre" wrote in message ... Hi, I'm wondering if there a way to open a workbook into a new application by default. So, when you double-click the excel workbook, it will start in a new Excel application. I think about something in the Open event but I don't know how to cancel the process and restart it into an other application. Thank you! Alex -- Alex St-Pierre . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to open a workbook into a new Excel application
As I said before...
I have seen multiple instances of Excel running at the same time on one machine. Here the normal instance was started by either double clicking the file or the Excel icon. The next instance was started from a command window. See attached image. I was able to run multiple instances of Excel 2007. However, if you setup a default Toolbar/CommandBar it will startup with each instance. You could use the Workbook_Open macro to prompt you for a selection of which Toolbar/CommandBar to use. Dennis "Dennis Tucker" wrote in message ... Alex, Excel is an application. Normally Excel runs with only a single instance of itself. You can do OLE linking with programs like MS Word. This sort of runs Excel inside Word. I have seen multiple instances of Excel running at the same time on one machine. Here the normal instance was started by either double clicking the file or the Excel icon. The next instance was started from a command window. So I'm not to sure what you mean by opening a workbook in a new application. Dennis "Alex St-Pierre" wrote in message ... Hi, I'm wondering if there a way to open a workbook into a new application by default. So, when you double-click the excel workbook, it will start in a new Excel application. I think about something in the Open event but I don't know how to cancel the process and restart it into an other application. Thank you! Alex -- Alex St-Pierre |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to open a workbook into a new Excel application
Hi Dennis,
I can't see the image. Which program are you using for the newsgroup? I use the website "http://www.microsoft.com/communities/newsgroups/ ..." but I would like to use a better program. Thank you! Alex -- Alex St-Pierre "Dennis Tucker" wrote: As I said before... I have seen multiple instances of Excel running at the same time on one machine. Here the normal instance was started by either double clicking the file or the Excel icon. The next instance was started from a command window. See attached image. I was able to run multiple instances of Excel 2007. However, if you setup a default Toolbar/CommandBar it will startup with each instance. You could use the Workbook_Open macro to prompt you for a selection of which Toolbar/CommandBar to use. Dennis "Dennis Tucker" wrote in message ... Alex, Excel is an application. Normally Excel runs with only a single instance of itself. You can do OLE linking with programs like MS Word. This sort of runs Excel inside Word. I have seen multiple instances of Excel running at the same time on one machine. Here the normal instance was started by either double clicking the file or the Excel icon. The next instance was started from a command window. So I'm not to sure what you mean by opening a workbook in a new application. Dennis "Alex St-Pierre" wrote in message ... Hi, I'm wondering if there a way to open a workbook into a new application by default. So, when you double-click the excel workbook, it will start in a new Excel application. I think about something in the Open event but I don't know how to cancel the process and restart it into an other application. Thank you! Alex -- Alex St-Pierre . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to open a workbook into a new Excel application
It looks like the image is being blocked.
Basically you open a windows "command" window then start Excel from the command window. Dennis "Alex St-Pierre" wrote in message ... Hi Dennis, I can't see the image. Which program are you using for the newsgroup? I use the website "http://www.microsoft.com/communities/newsgroups/ ..." but I would like to use a better program. Thank you! Alex -- Alex St-Pierre "Dennis Tucker" wrote: As I said before... I have seen multiple instances of Excel running at the same time on one machine. Here the normal instance was started by either double clicking the file or the Excel icon. The next instance was started from a command window. See attached image. I was able to run multiple instances of Excel 2007. However, if you setup a default Toolbar/CommandBar it will startup with each instance. You could use the Workbook_Open macro to prompt you for a selection of which Toolbar/CommandBar to use. Dennis "Dennis Tucker" wrote in message ... Alex, Excel is an application. Normally Excel runs with only a single instance of itself. You can do OLE linking with programs like MS Word. This sort of runs Excel inside Word. I have seen multiple instances of Excel running at the same time on one machine. Here the normal instance was started by either double clicking the file or the Excel icon. The next instance was started from a command window. So I'm not to sure what you mean by opening a workbook in a new application. Dennis "Alex St-Pierre" wrote in message ... Hi, I'm wondering if there a way to open a workbook into a new application by default. So, when you double-click the excel workbook, it will start in a new Excel application. I think about something in the Open event but I don't know how to cancel the process and restart it into an other application. Thank you! Alex -- Alex St-Pierre . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to open a workbook when application excel is running ? | Excel Programming | |||
start an external application on workbook open | Excel Programming | |||
Need workbook w/ VBA to open in new & separate application window | Excel Programming | |||
Application Error when running Macro on Workbook open | Excel Programming | |||
Application Error when running Macro on Workbook open | Excel Programming |