Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Control Issues
All of a sudden I am having problems with controls on my VBA forms. I first
create a new form and place a few OOTB controls (command buttons, text boxes, combo boxes etc.). I run the form the first time to get an idea how it will look and have no problems. I will then add and adjust controls. Then, as I run the form I sporadically get and error message saying "Could not find the specified object." and all my latest changes to the form are lost. I find that if I save before I run the form and then close out of the xls, all changes are current as I re-open the file. I have tried this on five or six files thinking that it might be a fluke. All have the same problem. The thing that is strange is that I have done this many times before and never had any issues until now. Thanks for any insight. -- Chris Picklesimer |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Control Issues
First, close all applications. then find the temp directory
( before closing excel, in the immediate window do ? environ("Temp") ) No go to that location in Windows explorer or with the command prompt window and delete any files there and any subdirectories (and files) below temp, particularly any associated with Office produces or VBA/VBE. (particularly *.erd files). then try it. -- Regards, Tom Ogilvy "Chris Picklesimer" wrote: All of a sudden I am having problems with controls on my VBA forms. I first create a new form and place a few OOTB controls (command buttons, text boxes, combo boxes etc.). I run the form the first time to get an idea how it will look and have no problems. I will then add and adjust controls. Then, as I run the form I sporadically get and error message saying "Could not find the specified object." and all my latest changes to the form are lost. I find that if I save before I run the form and then close out of the xls, all changes are current as I re-open the file. I have tried this on five or six files thinking that it might be a fluke. All have the same problem. The thing that is strange is that I have done this many times before and never had any issues until now. Thanks for any insight. -- Chris Picklesimer |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Control Issues
Another quick way to get to the Temp folder (still close all running
applications): Windows start button|Run %temp% (hit ok) And I think Tom mean *.exd files. (Typo alert patrol strikes again <bg.) Tom Ogilvy wrote: First, close all applications. then find the temp directory ( before closing excel, in the immediate window do ? environ("Temp") ) No go to that location in Windows explorer or with the command prompt window and delete any files there and any subdirectories (and files) below temp, particularly any associated with Office produces or VBA/VBE. (particularly *.erd files). then try it. -- Regards, Tom Ogilvy "Chris Picklesimer" wrote: All of a sudden I am having problems with controls on my VBA forms. I first create a new form and place a few OOTB controls (command buttons, text boxes, combo boxes etc.). I run the form the first time to get an idea how it will look and have no problems. I will then add and adjust controls. Then, as I run the form I sporadically get and error message saying "Could not find the specified object." and all my latest changes to the form are lost. I find that if I save before I run the form and then close out of the xls, all changes are current as I re-open the file. I have tried this on five or six files thinking that it might be a fluke. All have the same problem. The thing that is strange is that I have done this many times before and never had any issues until now. Thanks for any insight. -- Chris Picklesimer -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Control Issues
Thanks for the catches.
-- Regards, Tom Ogilvy "Dave Peterson" wrote: Another quick way to get to the Temp folder (still close all running applications): Windows start button|Run %temp% (hit ok) And I think Tom mean *.exd files. (Typo alert patrol strikes again <bg.) Tom Ogilvy wrote: First, close all applications. then find the temp directory ( before closing excel, in the immediate window do ? environ("Temp") ) No go to that location in Windows explorer or with the command prompt window and delete any files there and any subdirectories (and files) below temp, particularly any associated with Office produces or VBA/VBE. (particularly *.erd files). then try it. -- Regards, Tom Ogilvy "Chris Picklesimer" wrote: All of a sudden I am having problems with controls on my VBA forms. I first create a new form and place a few OOTB controls (command buttons, text boxes, combo boxes etc.). I run the form the first time to get an idea how it will look and have no problems. I will then add and adjust controls. Then, as I run the form I sporadically get and error message saying "Could not find the specified object." and all my latest changes to the form are lost. I find that if I save before I run the form and then close out of the xls, all changes are current as I re-open the file. I have tried this on five or six files thinking that it might be a fluke. All have the same problem. The thing that is strange is that I have done this many times before and never had any issues until now. Thanks for any insight. -- Chris Picklesimer -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Control Issues
hi i am sorry to reply to this post....but perhaps someone can tell me what I
am saying wrong in my post...I am not getting any response from anyone and i really need help. Tom Ogilvy wrote: Thanks for the catches. Another quick way to get to the Temp folder (still close all running applications): [quoted text clipped - 38 lines] -- Chris Picklesimer |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Control Issues
Thanks for your help!
-- Chris Picklesimer "Tom Ogilvy" wrote: First, close all applications. then find the temp directory ( before closing excel, in the immediate window do ? environ("Temp") ) No go to that location in Windows explorer or with the command prompt window and delete any files there and any subdirectories (and files) below temp, particularly any associated with Office produces or VBA/VBE. (particularly *.erd files). then try it. -- Regards, Tom Ogilvy "Chris Picklesimer" wrote: All of a sudden I am having problems with controls on my VBA forms. I first create a new form and place a few OOTB controls (command buttons, text boxes, combo boxes etc.). I run the form the first time to get an idea how it will look and have no problems. I will then add and adjust controls. Then, as I run the form I sporadically get and error message saying "Could not find the specified object." and all my latest changes to the form are lost. I find that if I save before I run the form and then close out of the xls, all changes are current as I re-open the file. I have tried this on five or six files thinking that it might be a fluke. All have the same problem. The thing that is strange is that I have done this many times before and never had any issues until now. Thanks for any insight. -- Chris Picklesimer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Difference between a Forms Control verus Active-X Control | Excel Discussion (Misc queries) | |||
Programatically control picture property of Image control | Excel Programming | |||
Calendar Control issues | Excel Programming | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming |