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)" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems from changing from Excel 97 to Excel 2002 (Office 97 to Office XP)
What your code shows is adding code to a procedure. Not sure what that has
to do with the problem described. Unless you are placing your combobox dynamically, there really shouldn't be a reason to write code dynamically to get the selection. -- Regards, Tom Ogilvy Greener wrote in message om... 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(""Our List"").Object.ListIndex,1)" |
Reply |
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) |