Programmatically Merge Excel Files

[Tero]

I have written a C# application that uses third party code (Farpoint Spread)
that will export to an Excel (.xls, 2003 compatible) file. I want to allow
the user to modify the data in Excel, after which my C# application will
import the .xls file. I have written VBA code in an Excel template file
(.xlt) that prohibits the userfrom entering invalid data. I need to figure
out a way to merge the two files so that my VBA code works with the generated
data in the .xls file. I want do this automatically from my C# application
when I programatically open the Excel file. How can I merge or copy the
generated .xls data file with my VBA macro code located in the template .xlt
file?

 

[JLGWhiz]

Can you not open the template and then import the .xls file that the user
modified and save it as a different filename?