Hello,

i'm writing macro in excel (VBA programming), and i have a strange problem:
when my macro is running, i can not open another excel workbooks....

since my macro is for managing stock, i really need the possibility to open
excel files in background.

any ideas?

Thanks, Tomer

It is not strange that is what you would expect. Open another instance of
Excel if your system resources allows and use that

--

Regards,
Nigel




"Tomer" wrote in message
...
Hello,

i'm writing macro in excel (VBA programming), and i have a strange
problem:
when my macro is running, i can not open another excel workbooks....

since my macro is for managing stock, i really need the possibility to
open
excel files in background.

any ideas?

Thanks, Tomer

Hello again,

what do you mean by "open another instance of excel?"...
what exactly should i do?
non of the regular manners of opening an excel file works..

Thanks, Tomer

"Nigel" wrote:

It is not strange that is what you would expect. Open another instance of
Excel if your system resources allows and use that

--

Regards,
Nigel




"Tomer" wrote in message
...
Hello,

i'm writing macro in excel (VBA programming), and i have a strange
problem:
when my macro is running, i can not open another excel workbooks....

since my macro is for managing stock, i really need the possibility to
open
excel files in background.

any ideas?

Thanks, Tomer

hi Tomer,
One instance of excel is an open copy of the excel application which may
contain multiple open workbooks. To open a second instance open the
application again directly (rather than opening a file) this can be done by
(well, on my computer anyway):
Start Menu - Run - "Excel.exe" [enter]
or
Start Menu - All Programmes - MS Office - MS Excel


hth
Rob
__________________
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


"Tomer" wrote:

Hello again,

what do you mean by "open another instance of excel?"...
what exactly should i do?
non of the regular manners of opening an excel file works..

Thanks, Tomer

"Nigel" wrote:

It is not strange that is what you would expect. Open another instance of
Excel if your system resources allows and use that

--

Regards,
Nigel




"Tomer" wrote in message
...
Hello,

i'm writing macro in excel (VBA programming), and i have a strange
problem:
when my macro is running, i can not open another excel workbooks....

since my macro is for managing stock, i really need the possibility to
open
excel files in background.

any ideas?

Thanks, Tomer

Thanks....it works

Tomer

"broro183" wrote:

hi Tomer,
One instance of excel is an open copy of the excel application which may
contain multiple open workbooks. To open a second instance open the
application again directly (rather than opening a file) this can be done by
(well, on my computer anyway):
Start Menu - Run - "Excel.exe" [enter]
or
Start Menu - All Programmes - MS Office - MS Excel


hth
Rob
__________________
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


"Tomer" wrote:

Hello again,

what do you mean by "open another instance of excel?"...
what exactly should i do?
non of the regular manners of opening an excel file works..

Thanks, Tomer

"Nigel" wrote:

It is not strange that is what you would expect. Open another instance of
Excel if your system resources allows and use that

--

Regards,
Nigel




"Tomer" wrote in message
...
Hello,

i'm writing macro in excel (VBA programming), and i have a strange
problem:
when my macro is running, i can not open another excel workbooks....

since my macro is for managing stock, i really need the possibility to
open
excel files in background.

any ideas?

Thanks, Tomer

Pleased I could help, thanks for the feedback :-)

Rob
__________________
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


"Tomer" wrote:

Thanks....it works

Tomer

"broro183" wrote:

hi Tomer,
One instance of excel is an open copy of the excel application which may
contain multiple open workbooks. To open a second instance open the
application again directly (rather than opening a file) this can be done by
(well, on my computer anyway):
Start Menu - Run - "Excel.exe" [enter]
or
Start Menu - All Programmes - MS Office - MS Excel


hth
Rob
__________________
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


"Tomer" wrote:

Hello again,

what do you mean by "open another instance of excel?"...
what exactly should i do?
non of the regular manners of opening an excel file works..

Thanks, Tomer

"Nigel" wrote:

It is not strange that is what you would expect. Open another instance of
Excel if your system resources allows and use that

--

Regards,
Nigel




"Tomer" wrote in message
...
Hello,

i'm writing macro in excel (VBA programming), and i have a strange
problem:
when my macro is running, i can not open another excel workbooks....

since my macro is for managing stock, i really need the possibility to
open
excel files in background.

any ideas?

Thanks, Tomer