Export VB.Net EXE form values to word doc on client PC

Question

0.00/5 (No votes)

See more:

Morning guys and girls

I'm stuck between a rock and a hard place and I would appreciate any type of help.

I have created an .EXE to be emailed/written to cd and then given to a client off site.

The programme takes some values filled into textboxes by the client to perform a couple of calculations and then, in a couple of other textboxes give the client results.

I then export/generate a temporary office word document that contains all these textbox values, print the document and then deletes the word file. The reason is that we don't want digital copies of results available, since the client just might change the document.

Now this all work well on my pc as it should. I then tried it on other pcs in the office and found that some are not running the .Net 3.5 framework and has to be installed to run, this I sorted out by attaching the .Net 3.5 framework to the cd or email to the client.

Then I got another error... This makes reference to 'Microsoft.Office.Interop.Word' which I understand to be a serial number/version number problem blah blah blah. I have read that you can download the fix for this but the thing is I don't want the client to download "10" fixes before they can use the programme, it must be open, use, print, close, done.

What else can I do to export information to a document containing graphics like logos etc, print the document and then delete?

Posted 7-Feb-13 0:26am

JacquesGrobler

Add a Solution

Comments

_Vitor Garcia_ 7-Feb-13 6:36am

Instead of working with MS Word, could you produce a PDF file ?

JacquesGrobler 7-Feb-13 6:40am

I can have a pdf, but if the client only has a "pdf printer", can this still be done? It doens't matter what means, as long as it works and as long as the client doesn't require any additonal software to operate the programme.

Then the next question is, can .Net alter an existing pdf?

_Vitor Garcia_ 7-Feb-13 7:10am

You can create a PDF file from scratch. Take a look here http://www.codeproject.com/Questions/160004/how-to-create-pdf-file-in-vb-net

CHill60 7-Feb-13 6:41am

Could you produce an RTF file?

JacquesGrobler 7-Feb-13 6:44am

What is an RTF file? Can it incorporate company logos, other text than what is in the exe?

CHill60 7-Feb-13 6:46am

RTF = Rich Text Format. I believe it can hold logos ... check out the use of RichTextBox control

CHill60 7-Feb-13 6:50am

Just found this which might help http://stackoverflow.com/questions/1490734/programatically-adding-images-to-rtf-document

JacquesGrobler 7-Feb-13 6:52am

Thanks Chill

Having a look now, will let you know.

JacquesGrobler 7-Feb-13 7:06am

Do you perhaps have an example of how this works as I have never seen this before?

CHill60 7-Feb-13 8:27am

Found it! Not surprisingly somewhere in CodeProject :-) Have a look at this link http://www.codeproject.com/Articles/98062/RTF-Document-Constructor-Library -
There is also a specific question with another code snippet in the comments afterwards - a long way down though! The code is in C# but there are plenty of conversion tools around (e.g. http://www.developerfusion.com/tools/convert/csharp-to-vb/)

Mike Meinz 7-Feb-13 9:39am

This solves the version issue for the Word InterOp Assembly in Visual Studio 2012.

After you Add the Reference to Microsoft.Office.InterOp.Word in your project, select Microsoft.Office.InterOp.Word in the list of added references and then click Properties. In the Properties dialog, change Specific Version to False.

JacquesGrobler 8-Feb-13 2:04am

Hi Mike

I can't see the option to change the version under the properties dialog

JacquesGrobler 8-Feb-13 2:44am

Sorry, I see that I can do this in VS 2012, I unfortunately run 2008

CHill60 7-Feb-13 11:12am

Also found this http://www.codeproject.com/Articles/10999/Printing-Word-Documents-in-C - where the chap has tried to make it non-version specific by using .PrintOutOld

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Boris Fisher · Answer 1 · 2013-08-03T02:56:00

Solution 1

You can check this:
http://netoffice.codeplex.com/documentation

Posted 3-Aug-13 2:56am

Boris Fisher

Updated 3-Aug-13 2:57am

v2