How to open a workbook into a new Excel application

A

Alex St-Pierre

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
 
D

Dennis Tucker

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
 
A

Alex St-Pierre

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
 
D

Dennis Tucker

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
 
D

Dennis Tucker

It looks like the image is being blocked.

Basically you open a windows "command" window then start Excel from the
command window.


Dennis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top