VSTO Merge or import workbooks

T

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top