Execute separately

[PeCoNe]

Hi There,

On the desktop there is a shortcut for an excel program.
When i click on it, the excel opens but connects to an running excel.
How can change it so it becomes a separate program?

Bye Peter Maljers

 

[GS]

Hi There,

On the desktop there is a shortcut for an excel program.
When i click on it, the excel opens but connects to an running excel.
How can change it so it becomes a separate program?

Bye Peter Maljers

Use a frontloader and have the Excel file open in an automated instance
rather than the default instance.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Puppet_Sock]

Use a frontloader and have the Excel file open in an automated instance
rather than the default instance.

To the OP, just to clarify: You mean you have a shortcut
to an Excel file. And if you already have that file open,
then double-clicking the shortcut to the file will hook you
to the open file, not open a new copy.

If you open a new session of Excel, then open the file
from that session, you get a read-only-session.

One might wonder at the wisdom of using the action of
opening Excel to make a copy of a file. If what you want
is really two Excel sessions editing the same file, maybe
you want to copy the file before you open it.
Socks

 

[PeCoNe]

Op 2013-04-17 18:34, Puppet_Sock schreef:

To the OP, just to clarify: You mean you have a shortcut
to an Excel file. And if you already have that file open,
then double-clicking the shortcut to the file will hook you
to the open file, not open a new copy.

If you open a new session of Excel, then open the file
from that session, you get a read-only-session.

One might wonder at the wisdom of using the action of
opening Excel to make a copy of a file. If what you want
is really two Excel sessions editing the same file, maybe
you want to copy the file before you open it.
Socks

I have 2 excel files X1 and X2
A shortcut was created for both excels S1 and S2
I start by clicking S1, then X1 starts running.
X1 is updated every minute by web query.
Then i start X2 by clicking S2
Excel 2 starts and when X1 is updated it comes to the front
Excel 2 is then not on screen anymore
So i want a new start of excel for the second excel so it does not
connect to excel 1.
At end i have 2 excels running.

I hope it is clear now.
How do i do that?

 

[GS]

Excel 2 starts and when X1 is updated it comes to the front

Excel 2 is then not on screen anymore

How do you know Excel 2 is not running? Are you saying it closes when
Excel 1 takes focus? Are you sure Excel 1 isn't just covering up Excel
2? Does the query update affect the file in Excel 2 in any way?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[PeCoNe]

Op 2013-04-17 19:11, GS schreef:

How do you know Excel 2 is not running? Are you saying it closes when
Excel 1 takes focus? Are you sure Excel 1 isn't just covering up Excel
2? Does the query update affect the file in Excel 2 in any way?

On the taskbar i have an excel icon.
Now i click on S1 on the desktop.
Excel 1 starts.
If i click on S2 on the desktop exel 2 connects to excel 1.

So i do the following instead:
I click right on the excel on the task bar.
I click on microsoft excel 2010 in the popup list.
A new fresh copy of excel starts.
Than i choose for open and select the second excel.
Now i have two excels running and when query updates excel 1,
excel 2 stays in front.

In other words i need two shortcuts which starts each a separate excel.
Thanks Peter/

 

[GS]

Op 2013-04-17 19:11, GS schreef:

On the taskbar i have an excel icon.
Now i click on S1 on the desktop.
Excel 1 starts.
If i click on S2 on the desktop exel 2 connects to excel 1.

So i do the following instead:
I click right on the excel on the task bar.
I click on microsoft excel 2010 in the popup list.
A new fresh copy of excel starts.
Than i choose for open and select the second excel.
Now i have two excels running and when query updates excel 1,
excel 2 stays in front.

In other words i need two shortcuts which starts each a separate
excel.
Thanks Peter/

Perhaps your terminology is confusing me! If, as you say, you open the
2nd file from Excel after opening the 1st file then you only have 1
instance of Excel running with 2 files open. In this case you can
switch between the 2 files using *Ctrl+Tab* so you can have whichever
file you want be the *Active Window*.

So for clarity...

Excel is an application that can have multiple running instances.

Shortcuts on your desktop to Excel files stored somewhere are not
"Excels", they are Excel files.

So if you open Excel 2 times you have 2 separate running instances of
Excel.

If you open 2 (or more) Excel files in a single running instance of
Excel then to work with each file you need to *Switch Windows* to the
window that contains the file you want to work with. You can do this
via the *View* tab in the *Window* section, OR use the keyboard
shortcut I mentioned earlier.<g>

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Puppet_Sock]

Shortcuts on your desktop to Excel files stored somewhere are not
"Excels", they are Excel files.

Well... Technically, a shortcut is a Windows file. It has a
file extension of .lnk. If it points at Excel or an Excel
file then Windows may show the icon as Excel.
Socks

 

[Puppet_Sock]

I have 2 excel files X1 and X2
A shortcut was created for both excels S1 and S2
I start by clicking S1, then X1 starts running.
X1 is updated every minute by web query.
Then i start X2 by clicking S2
Excel 2 starts and when X1 is updated it comes to the front
Excel 2 is then not on screen anymore
So i want a new start of excel for the second excel so it does not
connect to excel 1.
At end i have 2 excels running.

I hope it is clear now.
How do i do that?

I don't think you want a new start of Excel.
I think you just want to bring an instance to
visibility if it gets hidden. Completely different
issue.

Try putting each Excel in just part of the screen.
If one closes, then find out what closed it. It
shouldn't close just because you started up another.
Socks

 

[GS]

[snip]

Shortcuts on your desktop to Excel files stored somewhere are not
"Excels", they are Excel files.

Well... Technically, a shortcut is a Windows file. It has a
file extension of .lnk. If it points at Excel or an Excel
file then Windows may show the icon as Excel.
Socks

The OP infers that the shortcuts point to Excel files (X1 and X2)! The
desktop icon will naturally (by default) use the icon of the associated
app. I didn't see any point to mention this as it seems (so it turns
out) the OP didn't know how to toggle windows of open files in a single
instance. I initially thought (by the wording) that separate running
instances of Excel were what was wanted.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[PeCoNe]

Op 2013-04-18 19:13, GS schreef:

The OP infers that the shortcuts point to Excel files (X1 and X2)! The
desktop icon will naturally (by default) use the icon of the associated
app. I didn't see any point to mention this as it seems (so it turns
out) the OP didn't know how to toggle windows of open files in a single
instance. I initially thought (by the wording) that separate running
instances of Excel were what was wanted.

Yes Garry that is what i wont.
i started an excel and right clicked on the taskbar to fix the icon.
if i now click on the icon on the taskbar it connects to the running excel
if i click again on the taskbar it connects the just opened excel
if i right click on the icon on the taskbar than it opens a popup window
and i can start a fresh copy of excel and now excel is running twice

I want to do exactly the same, but only with two shortcuts on the desktop

Bye Peter

 

[GS]

Op 2013-04-18 19:13, GS schreef:

[snip]
Shortcuts on your desktop to Excel files stored somewhere are not
"Excels", they are Excel files.

Well... Technically, a shortcut is a Windows file. It has a
file extension of .lnk. If it points at Excel or an Excel
file then Windows may show the icon as Excel.
Socks

The OP infers that the shortcuts point to Excel files (X1 and X2)!
The
desktop icon will naturally (by default) use the icon of the
associated
app. I didn't see any point to mention this as it seems (so it
turns
out) the OP didn't know how to toggle windows of open files in a
single
instance. I initially thought (by the wording) that separate
running
instances of Excel were what was wanted.

Yes Garry that is what i wont.
i started an excel and right clicked on the taskbar to fix the icon.
if i now click on the icon on the taskbar it connects to the running
excel
if i click again on the taskbar it connects the just opened excel
if i right click on the icon on the taskbar than it opens a popup
window and i can start a fresh copy of excel and now excel is running
twice

I want to do exactly the same, but only with two shortcuts on the
desktop

Bye Peter

You have to work within the allowable parameters of Excel! I have no
idea why anyone would want to deliberately have more than 1 running
instance of Excel, because of the added burden on system resources.
(but then what do I know?!) You can strat more instances via the
right-click menu of the Taskbar icon for any app that allows multiple
instances. (Not all do: Outlook, for example)

As I stated in my 1st reply, you can have multiple (separate) instances
of Excel open when you use a frontloader app to create automated
instances. This is what my apps do, so they each run their own instance
of Excel.

I can also create multiple running instances by holding down the *Ctrl*
when I click an icon on my FreeBar. (FreeBar is a stand-alone
replacement for the Office Shortcut Bar) There's probably other ways
via Windows Explorer but these are the 3 methods I use most often.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion