Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems from changing from Excel 97 to Excel 2002 (Office 97 to Office XP)
We have got an Excel/VBA application working very well with Excel 97:
in dropdown boxes, we were able to double click an item in a dropdown box to select it using OLEOBJECTS. As we change to Office XP (Excel 2002), one problem occurred: now, the very same action wouldn't be able to select any item from the dropdown box, and there was NO error message at all. It seems that the program, for some unknown reason, skips the OLEOBJECTS. Any one has the similar experience or knows the back-end of Excel 2002? Is there any change in terms of OLEOBJECTS from Microsoft when their upgrading from Excel 97 to 2002? Thanks all! ..InsertLines .CountOfLines + 1, " strSection = ActiveSheet.OLEObjects(""OurList"").Object.List(Ac tiveSheet.OLEObjects(""OurList"").Object.ListIndex ,1)" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
office 2003 run on office 2007 problems??? | Excel Discussion (Misc queries) | |||
Office XP Professional - Excel 2002 | Excel Discussion (Misc queries) | |||
Excel 2002 office xp | Excel Discussion (Misc queries) | |||
Unable to open Office 2007 files using Office 2002 XP | Excel Discussion (Misc queries) | |||
Office 2002 excel search | Excel Discussion (Misc queries) |