Excel Addin works that works on a template workbook

[s.jay_k]

Hi,

I am developing an Excel Add-in in VC++ that has to receive a user submitted
template workbook, create a workbook based on this template and populate it's
contents with some values. The user submitted template can change. Is there
any known way to accomplish this (perhaps use some sort of XML technique)?

Can someone please advise me on how to go about doing this
Regards

 

[Patrick Smith [MSFT]]

You say that the template can change...is that the format of the template or
the entire template file? The reason I ask is that I wonder if Field names
(named ranges) would allow you to get the info you need from the template.
If the layout of the template changes, but the proper named ranges move to
the correct cells, then maybe that would work.

Hope this helps,