View Full Version : vb.net brought to my knees - can Word help?

03-01-2011, 07:21 PM
I have been learning vb.net for 6 months to write a prog that does lots of caculations, each several pages long.

However, I have just learnt that vb.net does net let you display long forms, as you are limited by the screens reolution.

I stopped for a while and looked at other languages but then had a thought. Is it possible to use the VB form to get input and do calcs but send the answer to a Word document.

I would need the Word doc to look good, I.e control how a lay out text, be able to add images etc. The idea is that the result can be emailed to the user.

Is this realistic or do I need to consider alternative languages?

Any help appreciated.

03-01-2011, 07:47 PM
Have you looked into using scrollbars with your VB program? You should be able to create a form larger than the users display and allow your users to scroll through the form. You could also just have a forward and back button at the bottom of your form, so the user can navigate through the different "pages."

I was told that in word, you can create bookmarks where you can then use VB to insert information at those bookmarks. How this works exactly is beyond me.

Another solution to look into are spread sheets. They can format text, display images, and calculate numbers based on user input. If you create your spread sheet to work with OpenOffice, then anyone can use your calculation thingy for free. OpenOffice also supports tabbed files, which means you can make several spreadsheets and put them in one file.

03-01-2011, 09:19 PM
Hey HeavierMosquito,

Let me make sure I understand you correctly. You are having trouble displaying certain calculation results. The problem is that these results are long and therefore don't fit on the screen.

1. Why not put your results in a multiline textbox with a vertical scroll or something like that?

2. Regarding the form height, you can just set whatever height you want and it will display whatever fits on your screen, so I don't understand what problem you are having here? And again, referring to my 1st point above would make this point irrelevant.

3. As far as putting your results in a word document, sounds like you need to use MS Word Automation. Just google that and you will see plenty of examples, no need to reiterate it here.


03-08-2011, 01:46 PM
Thanks guys,

With regards the use of scroll bars this is not really applicable because one limitation of the .net platform is that the extent to which you can scroll is limited. Multiline text boxes are an option but with the amount of things that I need to put in it is not ideal.

I have looked into Automation and to me this appears to be the way to go. Hopefully I can get some people to buy the calculations when they are more advanced but Automation will mean that the user needs Microsoft Word, although the majority of people do so this is no major problem.

Thanks again for your help.

Heavier Mosquito.