Re: Macros in a Form

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

Thank you for your response, and I am currently looking through some of the
articles on the sight you recommended. It is an excellent resource.

Well, I've thought of creating a template and having them create documents
based on it. I really do not want them to turn in 15 different documents to
me when it is complete. Let me explain myself further and perhaps someone
will come up with an even better way of doing what I'm trying to do.

I work a support job, in which people take online courses. The
administrators of the facilities sometimes choose to set up a "customized
curriculum". This means that some job codes/departments will be assigned a
set of courses.

So, my problem is they don't turn these in uniformly from facility to
facility. I have created a template so that they will all look a like when
they come back to our support desk. I need this to be as easy on my clients
as possible. So, I have created a word form (to keep them from changing the
questions) and I set up a macro in the last portion that copies this
"template section" and pastes it below it. The macro obviously does not work
because it will not add to the document while it is protected. I would just
give them a certain number of these "template sections" but they vary to
greatly. Some facilities might have 4 and some might have 24.

Any other ideas?

"Charles Kenyon" wrote:

> Give them a template of the form and let them create a new document based on
> the template when they need an additional form?
>
> What you are talking about is what Word calls an "online form." Check this
> in help. For more about online forms, follow the links at
> http://addbalance.com/word/wordwebresources.htm#Forms or
> http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm especially Dian
> Chapman's series of articles.
>
> Hope this helps,
> --
>
> Charles Kenyon
>
> Word New User FAQ & Web Directory: http://addbalance.com/word
>
> Intermediate User's Guide to Microsoft Word (supplemented version of
> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>
> See also the MVP FAQ: http://www.mvps.org/word which is awesome!
> --------- --------- --------- --------- --------- ---------
> This message is posted to a newsgroup. Please post replies
> and questions to the newsgroup so that others can learn
> from my ignorance and your wisdom.
>
> "macro troubleshooting" <macro troubleshooting@xxxxxxxxxxxxxxxxxxxxxxxxx>
> wrote in message news:885990C7-CF82-4C86-8B02-5F1DC169E6E9@xxxxxxxxxxxxxxxx
> >I have little to no programming experience.
> >
> > I have a form that my clients will fill out, but they may need the form
> > multiple times. There is no way to anticipate how many times they will
> > need
> > this form. So, I recorded a macro that copies and pastes the form. Then,
> > I
> > went and set the last field (which is a fill-in box) to run the macro upon
> > exit. The problem is that the form has to be protected for the form to
> > work.
> > The form protection prohibits the copy and paste.
> >
> > Does anyone have a better way to do this?
>
>
>
.

Relevant Pages

  • Re: Understanding Macros
    ... I have the newly created macro toolbar on the template. ... There is no panel on the left of the screen that opens that looks like ...
    (microsoft.public.word.docmanagement)
  • RE: word error
    ... your Normal.dot template may be infected with a macro virus. ... How to remove WLL add-ins and templates in the Word and Office Startup ... Startup folder is causing the problem, ...
    (microsoft.public.office.misc)
  • Re: How do I set up automatically suceeding numbers in Word?
    ... So I'll suggest that for each one you take the name of the template ... then the corresponding names inside the macro could be "Contract A ... "Jay Freedman" wrote: ... digits to display -- and not the number itself. ...
    (microsoft.public.word.docmanagement)
  • Re: How to control macros
    ... values for initalising a UserForm using document variables I'd be willing to ... When I initially create a document from a template, I set a flag to indicate ... As for a "global macro template", I don't have one - at least not for the ...
    (microsoft.public.word.vba.general)
  • Re: Changing default window properties
    ... What do YOU mean by "Global Template"? ... more than one macro of the same ... not willing to mess up my AutoOpen/New macros by testing this. ...
    (microsoft.public.mac.office.word)