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