Public variable Forgotten by VBA!
 

Hello!

I have a strange issue today with my VBA procedures in several workbooks. I
use many public variables, declared in general purpose modules.

Everything had been working fine until yesterday. I used to have 3 versions
of Excel in my machine: 2003, 2007 and 2010 Tech Preview. Yesterday I
uninstalled 2010 and 2003.

For some odd reason, since then VBA is "forgetting" the value of my public
variables!

I changed the scope of the variables to Global and now it works again, but
this does not seem to be an appropiate solution to the problem...

Anyone have a clue as to why this is happening?

Thanks in advance,

Albert C.

Public variable Forgotten by VBA!
 

You are not alone.
I had to do a System Restore after uninstalling the @2010 Tech Preview.
--
Jim Cone
Portland, Oregon USA



"Albert"
wrote in message
...
Hello!
I have a strange issue today with my VBA procedures in several workbooks. I
use many public variables, declared in general purpose modules.

Everything had been working fine until yesterday. I used to have 3 versions
of Excel in my machine: 2003, 2007 and 2010 Tech Preview. Yesterday I
uninstalled 2010 and 2003.
For some odd reason, since then VBA is "forgetting" the value of my public
variables!
I changed the scope of the variables to Global and now it works again, but
this does not seem to be an appropiate solution to the problem...
Anyone have a clue as to why this is happening?
Thanks in advance,
Albert C.

Public variable Forgotten by VBA!
 

Really???
Darn!
Sorry to hear that!


"Jim Cone" wrote:



You are not alone.
I had to do a System Restore after uninstalling the @2010 Tech Preview.
--
Jim Cone
Portland, Oregon USA



"Albert"
wrote in message
...
Hello!
I have a strange issue today with my VBA procedures in several workbooks. I
use many public variables, declared in general purpose modules.

Everything had been working fine until yesterday. I used to have 3 versions
of Excel in my machine: 2003, 2007 and 2010 Tech Preview. Yesterday I
uninstalled 2010 and 2003.
For some odd reason, since then VBA is "forgetting" the value of my public
variables!
I changed the scope of the variables to Global and now it works again, but
this does not seem to be an appropiate solution to the problem...
Anyone have a clue as to why this is happening?
Thanks in advance,
Albert C.