Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Public variable (or Public Const?) | Excel Programming | |||
Public variable (or Public Const?) | Excel Programming | |||
Public variable | New Users to Excel | |||
Public Variable | Excel Programming | |||
public variable | Excel Programming |