[thelist] IE / Excel / VB.Net / Word

[Peter Brunone (EasyListBox.com)]

   Okay, so Excel really doesn't enter into this at all; it's just the UI right now.  You'd create a Winform app that would do all that for you.  Then you just have to generate a Word document, which is much less of a headache than creating a real Excel spreadsheet.

   You could use a component like Aspose.Word ( http://www.aspose.com/Purchase/Aspose.Word/Default.aspx ) to create the document, but at $495 for a single-developer license, it may not be cost-effective for you... at least not yet.

   I would google on "generate Word document vb.net" and see what you get.  Basically, you're just going to use System.IO and create a text file which includes some formatting and has a .doc extension.  Even easier, you could create a Word doc that has all the necessary info/formatting, replace the data with placeholders (like <<FIRST_NAME>>), and then use it as a template with simple string replace operations.

   If you like, I can send you the source code for FileGlue, a tiny VB.NET app I wrote to stick log files together.  By looking through it, you can see how to open files and work with their contents, and then create a new file and save it to disk.

Cheers,

Peter

 From: Rob Smith rob.smith at THERMON.com

Maybe with more information on the process, we could at least
get you pointed in the right direction.

Well, step one is a questionnaire (excel). The user gives answers in dollar
amounts or a "y" or "no" answers. Then after a series of IF's and
calculations, you click a button called "Make Offer". This takes all the
inputs from the question and creates a word document/offer that can be given
to an owner of a property. He basically got tired of spending days on end
analyzing one property, and created this "software" to all him to make an
educated decision in 3 minutes or less. 

He wants to sell this software and I wanted to help. The problem I see with
having it it's current format is that it is easily redistributable.
Placing/Translating it into a VB.Net app and allow the user to create the
offers within the program is a much better solution for his needs.

Does this help?