Advice on Office Development Project RRS feed

  • Question

  • Hi Everyone,

    I am new to Office development and have a development project that requires a decision on which technology I should use. I need to have a custom Excel document template in which certain cells will be populated by drop-down lists which will be bound to an XML file on a server.  Initially I thought I would use VBA to do the work and a COM object written in C# that would be instantiated by VBA and would employ a web service to access the Web server to retrieve the data for the drop-down lists.  I am wondering if application level add-ins or document customization might be a better way to do this or if they are overkill.  

    Any advice would be greatly appreciated, and if someone has done something similar or can point me to an example or two that would be awesome!


    Monday, June 23, 2014 2:39 PM


All replies