Reputation: 73
I need to write a VB class that will create an Excel file and pass into this file a list of variables.
Afterwards I need to be able to convert the program to a .dll so that it can be called by a program.
Its been a while since I have written any code so thought that VB would be a good refresher but all the example I can find all start from within Excel. I need the call to create the file to be from outside of Excel.
Upvotes: 0
Views: 148
Reputation: 8009
I would recommend you look at the OpenXML SDK For Microsoft Office. Unlike many of the examples you'll find that use Microsoft.Office.Interop
, this approach does not require Microsoft Office to be installed.
There is a complete how-to on MSDN for generating Excel workbooks.
Upvotes: 1