Public variable Forgotten by VBA!

[Albert]

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.

 

[Jim Cone]

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



"Albert" <[email protected]>
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.

 

[Albert]

Really???
Darn!
Sorry to hear that!