excel macro problem

[Tomer]

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

 

[Nigel]

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

 

[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

 

[broro183]

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]

Thanks....it works

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...

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

 

[broro183]

Pleased I could help, thanks for the feedback

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

Thanks....it works

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...

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

:

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
(e-mail address removed)



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