The W
Views: 97864759
Main | FAQ | Search: Y! / G | Calendar | Color chart | Log in for more!
1.8.14 0102
The W - Internet & Computers - What should I start studying for this programming application?
This thread has 3 referrals leading to it
Register and log in to post!
Thread rated: 5.22
Pages: 1
(78 newer) Next thread | Previous thread
User
Post (4 total)
samoflange
Lap cheong








Since: 22.2.04
From: Cambridge, MA

Since last post: 288 days
Last activity: 280 days
#1 Posted on | Instant Rating: 3.38
I have about as close to zero experience with programming as you can get with a engineering degree. I've got an idea to streamline some things at my company, and want some basic advice on what I should start learning so that I can implement it.

I am envisioning a simple Windows program where the user can make selections from various options. These selections will then be used to generate a Word document once the user is finished.

Right now these documents are created by editing old ones, and cross-referencing with various reference documents so that the correct information gets put in. I'd like this program to have all of this reference information in it, so that the user can just make the selections they want (and be able to customize as need be), making the entire process more streamlined and idiot-proof.

From my very limited knowledge, Visual Basic would be the simplest, quickest way to get this done. Am I right in this? Are there any tutorials/guides that you would suggest for a beginning looking to start learning how to do all this?

(edited by samoflange on 6.9.11 1500)

Lloyd: When I met Mary, I got that old fashioned romantic feeling, where I'd do anything to bone her.
Harry: That's a special feeling.
Promote this thread!
Mr. Boffo
Scrapple








Since: 24.3.02
From: Oshkosh, WI

Since last post: 368 days
Last activity: 329 days
#2 Posted on | Instant Rating: 5.95
What kind of changes to the documents would it be making? Since you're dealing with Word files, I wonder if a Word template would do what you want. If not that then a macro should work. A macro is programmed in Visual Basic.

And that's really all I can add to the discussion.



I'm going to be walking in the National Kidney Foundation Kidney Walk in September, and I'm supposed to ask for donations. Links is at http://donate.kidney.org/site/TR/Walk/Wisconsin?px=1851193&pg=personal&fr_id=4180
samoflange
Lap cheong








Since: 22.2.04
From: Cambridge, MA

Since last post: 288 days
Last activity: 280 days
#3 Posted on | Instant Rating: 3.38
I've used templates in the past and I think it would end up being too complicated for this application. The type of information to be inputted could easily be mapped as a tree where you choose one of several choices, then are prompted for more information to narrow down what would be put into the document.

Here's a rough example:

-Select One or More
Type A
Type B
Type C
Type D

(choose Type B)

-Select Range
Range X, 0 to 100
Range Y, 0 to 200
Range Z, 0 to 300

(choose Range X)

---> The program should display the parameters for Type A, Range X in a text box that can be customized if desired. Upon completion, an 'export to document' button or something would be clicked on and these parameters would be put into the document at a specified location along with the choices of Type B and Range X.

There should also be option to pick more than one Type and the document created would then have more than one Type, Range, and Parameters.





Lloyd: When I met Mary, I got that old fashioned romantic feeling, where I'd do anything to bone her.
Harry: That's a special feeling.
Big G
Potato korv








Since: 21.8.03
From: the people who brought you Steel Magnolias....

Since last post: 11 days
Last activity: 19 hours
#4 Posted on | Instant Rating: 8.15
This smells like a VBA problem.

VBA (Visual Basic for Applications) is the language used for automating MS-Office. MS provides an object model API for every office application that's pretty well documented. (example - http://msdn.microsoft.com/​en-​us/​library/​ff841702.aspx)

In your copy of Word (I'm using Word 2010) you need to enable the developer toolbar. It's off by default. Go to file, options and then select Customize Ribbon. On the right tree view box, Main tabs, tick the developer node to display it and hit OK.

Hitting the far left button on the developer toolbar will open the Visual Basic editor.

There is much functionality available to you in VBA but it is very much the little brother of Windows programming though. When google searching, be sure to include VBA in your terms.

If you select Tools, References from the VBA menu, this is where you add additional libraries you may need to use, eg you can manipulate an Excel spreadsheet from within Word should you want to.

You can create and pop up forms to capture the information you need.

I'd recommend creating a template(s) depending on your needs with various bookmarks, fields, etc. pre-defined, just to make it easier to navigate your created document programmatically. After you collect the information from the user, you would spawn from your template rather than just a blank normal.

Have fun. I hope this helps.

(edited by Big G on 6.9.11 2230)
Thread rated: 5.22
Pages: 1
Thread ahead: Firefox updated again!?
Next thread: The thread in which Aaron discusses his iPad
Previous thread: Free speech analysis software for a Mac?
(78 newer) Next thread | Previous thread
I'm considering trying to get organized, to unload a lot of crap that I've accumulated over the last 20 years. The stuff I have ranges from books, to collectibles, to lots and lots of computer parts and video games.
The W - Internet & Computers - What should I start studying for this programming application?Register and log in to post!

The W™ message board

ZimBoard
©2001-2014 Brothers Zim

This old hunk of junk rendered your page in 0.07 seconds.