Prev: SOLVER Reset command does not work in 2007Excel why???? Two Questi
Next: delete file in addin directory
From: donvreug on 30 May 2010 08:57
Some of the macros I have written sometimes do not function correctly
if another instance of Excel is open. The other instance usually also
contains macros that may or may not have been executed. I thought I
read somewhere that this is a common problem but a recent search has
not turned up anything. Does anyone know of a solution to this or
any
tips to minimise the chances of this happening? I am using both
Excel
2003 and 2007. Thanks.
From: JLGWhiz on 30 May 2010 11:16
I can see where it might be a big problem if there are file names, sheet
namen or other names that are common to both versions of Excel or between
concurrent instances of the same version.


"donvreug" <donvreug(a)gmail.com> wrote in message
news:2ea5986c-f861-4643-b2d6-8ee5dcfee3b6(a)g1g2000pro.googlegroups.com...
> Some of the macros I have written sometimes do not function correctly
> if another instance of Excel is open. The other instance usually also
> contains macros that may or may not have been executed. I thought I
> read somewhere that this is a common problem but a recent search has
> not turned up anything. Does anyone know of a solution to this or
> any
> tips to minimise the chances of this happening? I am using both
> Excel
> 2003 and 2007. Thanks.


 | 
Pages: 1
Prev: SOLVER Reset command does not work in 2007Excel why???? Two Questi
Next: delete file in addin directory