userforms/templates/bookmarks/merge problems

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



I am currently tasked with creating a report template with a form to fill out
which then populates the document with the necessary information. I have
tried multiple suggestions I found on the internet and the MVP site, but
nothing seems to work. Should I make a form in Excel and then somehow link
it to a template and if so, how? In the form, there will be over a dozen
entries, with some needing to be selected from drop-down lists, populating a
60-page document (some entries will be one word, some paragraphs, and some
in-between). Presently I am trying to develop a template from an existing
document, bookmarking locations for information, then creating a userform
(problem area) to populate the document. I have never used Visual Basic
before and think that may be my hang-up.

I have a form for input of data; I need to populate the document with that
data. Don't know if I should use merge, ask, ref, bookmarks, or what, or if
form needs to be part of template. If so, or if not, I don't know if I need
a macro to run it when template is opened, or to add info to document.

I am using Word 2000 SP-3.

Thank you for any assistance you can provide.
.



Relevant Pages

  • Re: Tables and inserting rows
    ... I am trouble by your statement "I have the main template and then am inserting a document which has all the ... I would have everything set up in the template and if they want to create a document for another unit, they should be creating a new document from that template. ... The bookmark is inside the table of the document which gets attached. ... >> 'Add a row to the table and populate the cells in that row with>> the ...
    (microsoft.public.word.vba.general)
  • Re: Replacing merge fields in headers/footers
    ... database, and a newly populated document can be requested at any time. ... to my way of thinking is to have a merge template ... I'm using exactly the same code to populate the fields in the ... >> private FileStream PopulateTemplateDocument(int theFileID, ...
    (microsoft.public.word.vba.general)
  • RE: Data transfer to/from workbooks - Excel 2003
    ... but moving data to a CSV file may make the program ... I've created a mutli-sheet template where each sheet contains user input ... Add macroto enable users to select the previous version and go ... and populate the new template. ...
    (microsoft.public.excel.programming)
  • Re: Non Static Variables in a For...Next Loop
    ... Dim wbMain As Workbook, wbNew As Workbook ... ' the workbook with the template and the list ... It contains a Dealer ID Number, Name, Address, Phone, ... have vlookups on the Dealer template that populate Address, ...
    (microsoft.public.excel.programming)
  • Identity transformation problems
    ... I'm attempting to "populate" an template XML file with some data using ... identity transform (approach suggested by Joe K.; ... The transformation stylesheet is: ...
    (comp.text.xml)