| 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 | |||
Hybrid Mode
