• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 405
  • Last Modified:

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


1 Solution
Rory ArchibaldCommented:
Hi Martin,
Could you explain exactly what you mean by "from within a method of the worksheet, written in C#. " (a managed workbook solution?) and post a sample of what you have tried?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now