Help problem with macro and form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I did a questionnaire with word, for the first time I add a macro, the thing I did not know is that for a form you normally have to do a template, things I did not do. The problem is that I want to send this questionnaire by email and then to receive the answer back. How can I save the macro, to be sure it will work on other people' computer? I just wanted to send them a word doc and them to fill the form, this is so complex !! I did a macro to be sure that they cannot tick more than one box at a time. Please help me? I hope I was clear enough.

Thank you very much
 
G'day "Lycantrius" <[email protected]>,

You can 'manually' drag the code to the document using the Project
Explorer in the VBE. Once you have done that, you can email out 100
copies of that document :-)


Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)


Lycantrius reckoned:
 
WH has explained about putting the code into the document. Be aware of the
nightmare yet to come:

1) Many (possibly most) corporate networks will permanently block any Word
document containing macro code. YOU know that the macro is not malicious,
but they don't. So chances are, some of your users won't receive your form
at all; and some may even get a rude email from their Admin about the
nuisance you have caused.

2) If the document does get through, unless the users have the macro
security set to LOW -- which is not recommended for anybody connected to the
net -- they will get a security warning message, which some find scary, and
will lead some to disable the macro anyway.


All in all, you're going to wish you hadn't done this.




Lycantrius said:
Hello,

I did a questionnaire with word, for the first time I add a macro, the
Click to expand...
thing I did not know is that for a form you normally have to do a template,
things I did not do. The problem is that I want to send this questionnaire
by email and then to receive the answer back. How can I save the macro, to
be sure it will work on other people' computer? I just wanted to send them a
word doc and them to fill the form, this is so complex !! I did a macro to
be sure that they cannot tick more than one box at a time. Please help me? I
hope I was clear enough.
 
Back
Top