Refreshing List Object in Excel 2007 from Visual Studio Tools for the MS Office System
Hi Guys,
I've been trying to change the Command Text of a List Object in Excel 2007 during runtime from within a method of the worksheet, written in C#. The whole point is that the user should be able to select the table from a combo box and the list object should change accordingly.
Changing of the command text is mostly possible, but none of the refresh methods (neither of the whole workbook nor the List Object, Query Table, Connection or OLEDB-Connection) works.
The funny thing is that if I manually refresh in Excel, everything works fine.
Has somebody any clue how to refresh the data in the object from within the code?
Best Regards
Martin
I've been trying to change the Command Text of a List Object in Excel 2007 during runtime from within a method of the worksheet, written in C#. The whole point is that the user should be able to select the table from a combo box and the list object should change accordingly.
Changing of the command text is mostly possible, but none of the refresh methods (neither of the whole workbook nor the List Object, Query Table, Connection or OLEDB-Connection) works.
The funny thing is that if I manually refresh in Excel, everything works fine.
Has somebody any clue how to refresh the data in the object from within the code?
Best Regards
Martin
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.