Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing Objects in Excel VBA
While running Excel 97 SR-2b, the object "Date" seems to dissapear from the
VBA references. It is access correctly until my Excel template is loaded. Then the "Date" object is no longer found. I have reloaded Excel several times. I even loaded another copy of Excel just to see if it would work. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing Objects in Excel VBA
Maybe related to a missing reference in your template, in VBE see Tools
References and uncheck any marked missing. You may need to replace with similar avaiable in your system or for your version of Excel. Without solving the real problem but as a workaround try: MsgBox VBA.DateTime.Date If you're also missing string functions try: MsgBox VBA.Strings.Left("Hello",1) Regards, Peter "Lawrence A Murdock" <Lawrence A wrote in message ... While running Excel 97 SR-2b, the object "Date" seems to dissapear from the VBA references. It is access correctly until my Excel template is loaded. Then the "Date" object is no longer found. I have reloaded Excel several times. I even loaded another copy of Excel just to see if it would work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
missing chart objects in print preview (excel) | Charts and Charting in Excel | |||
objects missing in exixting worksheets | Excel Discussion (Misc queries) | |||
Unable to remove Sheet objects in the Microsoft Excel Objects | Excel Programming | |||
Missing: Microsoft ActiveX Data Objects Recordset 2.7 Library | Excel Programming | |||
Objects in VBA and Excel | Excel Programming |