Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 169
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 140
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 169
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 140
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 169
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 140
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to open a workbook when application excel is running ? Michel Angelosanto Excel Programming 4 May 26th 09 11:14 AM
start an external application on workbook open waterskyle Excel Programming 0 February 28th 08 07:19 PM
Need workbook w/ VBA to open in new & separate application window mikeolson Excel Programming 9 August 29th 06 02:56 PM
Application Error when running Macro on Workbook open TM[_2_] Excel Programming 1 October 2nd 03 10:53 AM
Application Error when running Macro on Workbook open TM[_2_] Excel Programming 0 September 15th 03 12:33 PM


All times are GMT +1. The time now is 02:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"