Exporting textbox data into MS word (VB.Net)

OmegaRed · 17-01-2007 8:23pm #1

Is it possible to take information from text boxes in a vb form and place them in specific places on a prepared MS word document?

I have a form which is taking details of an order (Product, Price, Quantity Totals) and I want to export this information into a word doc that has already been prepared with a logo. The document would be a invoice.

Just wondering is it actually possible because the searching I have done so far on Google is turning up results of exporting Crystal Reports to MS word.

Thanks

dazberry · 17-01-2007 9:28pm

I have done this before twice, both in Delphi using two different methods.

1. COM, Clipboard, RTF segments and parsing
Using COM I started Word, created a new document, and wrote out a few characters to the document. I cut the document to the clipboard and got the clipboard data type. Then I loaded up the relevent RTF segments in the application, parsed the variables in the RTF segments in memory, put the resulting segments back into the clipboard, and had Word paste them back into itself.

2. COM, Mailmerge
Had over 100 template letters with data coming from a Unix system. When I'd detect a new data file, using COM I'd start Word, load the template (which had mailmerge information) specifying the data file. Word would generate the letter and then using some trickery (changing printers, specifying printer trays etc) get Word to either print out the letters or print them to disk (for further FTPing to remote printers). I don't know if it is Word thing, a load thing of just the box they gave be but its a bit flakey.

HTH

D.

FSL · 18-01-2007 1:50am

Yes it's quite simple. In Vbasic open the word document template, fill the fields in the template with the date from the VB Form then save the form as as a new document, or print it, or email it, or if you have fax software fax it,

Exporting textbox data into MS word (VB.Net)

Comments