Discussion:
FAQ - frequently asked questions - vba - please read before posting - unofficial November posting
(too old to reply)
Charles Kenyon
2005-11-02 17:14:20 UTC
Permalink
FAQ = Frequently Asked Questions - brief - vba - unofficial

This FAQ is posted weekly.- more or less
Please save us all some time by reading it before posting to the
news group.

This newsgroup is about VBA - Visual Basic for Applications -
which is the programming language for Word 97-2003 (macros).
There is a longer FAQ with more questions and links that is
regularly posted in the non-VBA Word newsgroups. You may want
to check that out as well.

--- BEFORE POSTING ANYTHING PLEASE READ THESE ---

http://www.mvps.org/word/FindHelp/Posting.htm
http://www.dts-l.org/goodpost.htm

Reading these articles will help you get a quick and meaningful
response to your question rather than just more questions for you.
It may keep your message from being screened or bounced.

A few basics, though:
(1) Be nice; everyone answering questions here is a volunteer.
(2) Post a question in only one newsgroup generally. If you
_have to_ post in more than one, post a _single_ message and
put both newsgroups in the header for that _single_ message.
(3) Do not attach anything to a message.
(4) The only really stupid question is the one you don't ask.
(5) Do not use your real email address unless you want spam.
(See bottom for sample.)

The reasons for the requests are spelled out on the web page.

A longer version of this FAQ is also on the Internet at
http://addbalance.com/word/index.htm

Newsgroup Archives:
http://groups.google.com/advanced_group_search

MVPs FAQ site: http://www.mvps.org/word/ To the extent
there is any "official" FAQ, this is it.

---

Also, before posting, you may want to look at the following
questions to see if yours is among them.

---------- ---------- ---------- ---------- ---------- ----------
1. I see a macro in a newsgroup I would like to try. How
do I add it to my template?
http://addbalance.com/word/macrosfromnewsgroup.htm or
http://www.mvps.org/word/FAQs/MacrosVBA/CreateAMacro.htm

2. What are some good books for me to read about Word?
http://addbalance.com/word/wordbooks.htm and
http://www.mvps.org/word/Tutorials/BookRecommendations.htm

3. How can I run a macro automatically when a document opens,
closes, is created?
http://www.mvps.org/word/FAQs/MacrosVBA/DocumentEvents.htm

4. How can I distribute or backup macros / customizations?
http://word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm
http://addbalance.com/word/movetotemplate.htm

5. What is an MVP?
http://www.mvps.org/word/AboutMVPs/index.html and
http://addbalance.com/word/mvp.htm

6. I need to make a form to...

Userforms are custom dialog boxes written using vba.
If you want a fill-in-the-blanks form you want what Word
calls an online form. Look in Word's help for that,
and for more info on online forms follow the links at:
http://addbalance.com/word/wordwebresources.htm#Forms
especially Dian Chapman's series of articles

If you want a custom dialog box that you code with VBA commands
you want a UserForm. Take a look at:
http://www.mvps.org/word/FAQs/Userforms.htm

7. Where can I find more information on the Web?
http://addbalance.com/word/wordwebresources.htm#webvba
http://www.mvps.org/word/FAQs/MacrosVBA.htm
http://www.mvps.org/word/FAQs/Userforms.htm
http://www.mvps.org/word/FAQs/Customization.htm
http://www.mvps.org/word/FAQs/OfficeInterdev.htm

8. Recorded macros...
http://word.mvps.org/FAQs/MacrosVBA/UsingRecorder.htm
How do I edit or change?
http://word.mvps.org/FAQs/MacrosVBA/ModifyRecordedMacro.htm
Recorded macros are usually inefficient and sometimes just
plain don't work. Nevertheless, they often do work and can
be a good place to start!

9. How can I enter something once in a document and have it repeat
elsewhere? (Not really vba, but it keeps being asked.)
http://gregmaxey.mvps.org/Repeating_Data.htm

10. I can't save my customizations - AutoText, menus, etc.
Can't save normal.dot...
If you have Adobe Acrobat 7 installed see the last section of
http://www.gmayor.com/lose_that_adobe_acrobat_toolbar.htm.
Otherwise, hold down the Shift key when selecting the File
menu and select Save All.

11. How can I get a template to show up under a tab with
File => New?
What are templates? Global templates? Document templates?
http://addbalance.com/usersguide/templates.htm


Comments / corrections / additions may be sent to
***@no.spam.addbalance.com. Remove no.spam from the
address. (This is a "proofed" email address, I hope.)

Posted 2 November 2005

Charles Kenyon (the editor)
--
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://word.mvps.org/FAQs/ 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.
Charles Kenyon
2005-11-10 22:07:04 UTC
Permalink
FAQ = Frequently Asked Questions - brief - vba - unofficial

This FAQ is posted weekly.- more or less
Please save us all some time by reading it before posting to the
news group.

This newsgroup is about VBA - Visual Basic for Applications -
which is the programming language for Word 97-2003 (macros).
There is a longer FAQ with more questions and links that is
regularly posted in the non-VBA Word newsgroups. You may want
to check that out as well.

--- BEFORE POSTING ANYTHING PLEASE READ THESE ---

http://www.mvps.org/word/FindHelp/Posting.htm
http://www.dts-l.org/goodpost.htm

Reading these articles will help you get a quick and meaningful
response to your question rather than just more questions for you.
It may keep your message from being screened or bounced.

A few basics, though:
(1) Be nice; everyone answering questions here is a volunteer.
(2) Post a question in only one newsgroup generally. If you
_have to_ post in more than one, post a _single_ message and
put both newsgroups in the header for that _single_ message.
(3) Do not attach anything to a message.
(4) The only really stupid question is the one you don't ask.
(5) Do not use your real email address unless you want spam.
(See bottom for sample.)

The reasons for the requests are spelled out on the web page.

A longer version of this FAQ is also on the Internet at
http://addbalance.com/word/index.htm

Newsgroup Archives:
http://groups.google.com/advanced_group_search

MVPs FAQ site: http://www.mvps.org/word/ To the extent
there is any "official" FAQ, this is it.

---

Also, before posting, you may want to look at the following
questions to see if yours is among them.

---------- ---------- ---------- ---------- ---------- ----------
1. I see a macro in a newsgroup I would like to try. How
do I add it to my template?
http://addbalance.com/word/macrosfromnewsgroup.htm or
http://www.mvps.org/word/FAQs/MacrosVBA/CreateAMacro.htm

2. What are some good books for me to read about Word?
http://addbalance.com/word/wordbooks.htm and
http://www.mvps.org/word/Tutorials/BookRecommendations.htm

3. How can I run a macro automatically when a document opens,
closes, is created?
http://www.mvps.org/word/FAQs/MacrosVBA/DocumentEvents.htm

4. How can I distribute or backup macros / customizations?
http://word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm
http://addbalance.com/word/movetotemplate.htm

5. What is an MVP?
http://www.mvps.org/word/AboutMVPs/index.html and
http://addbalance.com/word/mvp.htm

6. I need to make a form to...

Userforms are custom dialog boxes written using vba.
If you want a fill-in-the-blanks form you want what Word
calls an online form. Look in Word's help for that,
and for more info on online forms follow the links at:
http://addbalance.com/word/wordwebresources.htm#Forms
especially Dian Chapman's series of articles

If you want a custom dialog box that you code with VBA commands
you want a UserForm. Take a look at:
http://www.mvps.org/word/FAQs/Userforms.htm

7. Where can I find more information on the Web?
http://addbalance.com/word/wordwebresources.htm#webvba
http://www.mvps.org/word/FAQs/MacrosVBA.htm
http://www.mvps.org/word/FAQs/Userforms.htm
http://www.mvps.org/word/FAQs/Customization.htm
http://www.mvps.org/word/FAQs/OfficeInterdev.htm

8. Recorded macros...
http://word.mvps.org/FAQs/MacrosVBA/UsingRecorder.htm
How do I edit or change?
http://word.mvps.org/FAQs/MacrosVBA/ModifyRecordedMacro.htm
Recorded macros are usually inefficient and sometimes just
plain don't work. Nevertheless, they often do work and can
be a good place to start!

9. How can I enter something once in a document and have it repeat
elsewhere? (Not really vba, but it keeps being asked.)
http://gregmaxey.mvps.org/Repeating_Data.htm

10. I can't save my customizations - AutoText, menus, etc.
Can't save normal.dot...
If you have Adobe Acrobat 7 installed see the last section of
http://www.gmayor.com/lose_that_adobe_acrobat_toolbar.htm.
Otherwise, hold down the Shift key when selecting the File
menu and select Save All.

11. How can I get a template to show up under a tab with
File => New?
What are templates? Global templates? Document templates?
http://addbalance.com/usersguide/templates.htm


Comments / corrections / additions may be sent to
***@no.spam.addbalance.com. Remove no.spam from the
address. (This is a "proofed" email address, I hope.)

Posted 10 November 2005

Charles Kenyon (the editor)
Charles Kenyon
2005-11-17 14:45:34 UTC
Permalink
FAQ = Frequently Asked Questions - brief - vba - unofficial

This FAQ is posted weekly.- more or less
Please save us all some time by reading it before posting to the
news group.

This newsgroup is about VBA - Visual Basic for Applications -
which is the programming language for Word 97-2003 (macros).
There is a longer FAQ with more questions and links that is
regularly posted in the non-VBA Word newsgroups. You may want
to check that out as well.

--- BEFORE POSTING ANYTHING PLEASE READ THESE ---

http://www.mvps.org/word/FindHelp/Posting.htm
http://www.dts-l.org/goodpost.htm

Reading these articles will help you get a quick and meaningful
response to your question rather than just more questions for you.
It may keep your message from being screened or bounced.

A few basics, though:
(1) Be nice; everyone answering questions here is a volunteer.
(2) Post a question in only one newsgroup generally. If you
_have to_ post in more than one, post a _single_ message and
put both newsgroups in the header for that _single_ message.
(3) Do not attach anything to a message.
(4) The only really stupid question is the one you don't ask.
(5) Do not use your real email address unless you want spam.
(See bottom for sample.)

The reasons for the requests are spelled out on the web page.

A longer version of this FAQ is also on the Internet at
http://addbalance.com/word/index.htm

Newsgroup Archives:
http://groups.google.com/advanced_group_search

MVPs FAQ site: http://www.mvps.org/word/ To the extent
there is any "official" FAQ, this is it.

---

Also, before posting, you may want to look at the following
questions to see if yours is among them.

---------- ---------- ---------- ---------- ---------- ----------
1. I see a macro in a newsgroup I would like to try. How
do I add it to my template?
http://addbalance.com/word/macrosfromnewsgroup.htm or
http://www.mvps.org/word/FAQs/MacrosVBA/CreateAMacro.htm

2. What are some good books for me to read about Word?
http://addbalance.com/word/wordbooks.htm and
http://www.mvps.org/word/Tutorials/BookRecommendations.htm

3. How can I run a macro automatically when a document opens,
closes, is created?
http://www.mvps.org/word/FAQs/MacrosVBA/DocumentEvents.htm

4. How can I distribute or backup macros / customizations?
http://word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm
http://addbalance.com/word/movetotemplate.htm

5. What is an MVP?
http://www.mvps.org/word/AboutMVPs/index.html and
http://addbalance.com/word/mvp.htm

6. I need to make a form to...

Userforms are custom dialog boxes written using vba.
If you want a fill-in-the-blanks form you want what Word
calls an online form. Look in Word's help for that,
and for more info on online forms follow the links at:
http://addbalance.com/word/wordwebresources.htm#Forms
especially Dian Chapman's series of articles

If you want a custom dialog box that you code with VBA commands
you want a UserForm. Take a look at:
http://www.mvps.org/word/FAQs/Userforms.htm

7. Where can I find more information on the Web?
http://addbalance.com/word/wordwebresources.htm#webvba
http://www.mvps.org/word/FAQs/MacrosVBA.htm
http://www.mvps.org/word/FAQs/Userforms.htm
http://www.mvps.org/word/FAQs/Customization.htm
http://www.mvps.org/word/FAQs/OfficeInterdev.htm

8. Recorded macros...
http://word.mvps.org/FAQs/MacrosVBA/UsingRecorder.htm
How do I edit or change?
http://word.mvps.org/FAQs/MacrosVBA/ModifyRecordedMacro.htm
Recorded macros are usually inefficient and sometimes just
plain don't work. Nevertheless, they often do work and can
be a good place to start!

9. How can I enter something once in a document and have it repeat
elsewhere? (Not really vba, but it keeps being asked.)
http://gregmaxey.mvps.org/Repeating_Data.htm

10. I can't save my customizations - AutoText, menus, etc.
Can't save normal.dot...
If you have Adobe Acrobat 7 installed see the last section of
http://www.gmayor.com/lose_that_adobe_acrobat_toolbar.htm.
Otherwise, hold down the Shift key when selecting the File
menu and select Save All.

11. How can I get a template to show up under a tab with
File => New?
What are templates? Global templates? Document templates?
http://addbalance.com/usersguide/templates.htm


Comments / corrections / additions may be sent to
***@no.spam.addbalance.com. Remove no.spam from the
address. (This is a "proofed" email address, I hope.)

Posted 17 November 2005

Charles Kenyon (the editor)
Charles Kenyon
2005-11-25 14:57:03 UTC
Permalink
FAQ = Frequently Asked Questions - brief - vba - unofficial

This FAQ is posted weekly.- more or less
Please save us all some time by reading it before posting to the
news group.

This newsgroup is about VBA - Visual Basic for Applications -
which is the programming language for Word 97-2003 (macros).
There is a longer FAQ with more questions and links that is
regularly posted in the non-VBA Word newsgroups. You may want
to check that out as well.

--- BEFORE POSTING ANYTHING PLEASE READ THESE ---

http://www.mvps.org/word/FindHelp/Posting.htm
http://www.dts-l.org/goodpost.htm

Reading these articles will help you get a quick and meaningful
response to your question rather than just more questions for you.
It may keep your message from being screened or bounced.

A few basics, though:
(1) Be nice; everyone answering questions here is a volunteer.
(2) Post a question in only one newsgroup generally. If you
_have to_ post in more than one, post a _single_ message and
put both newsgroups in the header for that _single_ message.
(3) Do not attach anything to a message.
(4) The only really stupid question is the one you don't ask.
(5) Do not use your real email address unless you want spam.
(See bottom for sample.)

The reasons for the requests are spelled out on the web page.

A longer version of this FAQ is also on the Internet at
http://addbalance.com/word/index.htm

Newsgroup Archives:
http://groups.google.com/advanced_group_search

MVPs FAQ site: http://www.mvps.org/word/ To the extent
there is any "official" FAQ, this is it.

---

Also, before posting, you may want to look at the following
questions to see if yours is among them.

---------- ---------- ---------- ---------- ---------- ----------
1. I see a macro in a newsgroup I would like to try. How
do I add it to my template?
http://addbalance.com/word/macrosfromnewsgroup.htm or
http://www.mvps.org/word/FAQs/MacrosVBA/CreateAMacro.htm

2. What are some good books for me to read about Word?
http://addbalance.com/word/wordbooks.htm and
http://www.mvps.org/word/Tutorials/BookRecommendations.htm

3. How can I run a macro automatically when a document opens,
closes, is created?
http://www.mvps.org/word/FAQs/MacrosVBA/DocumentEvents.htm

4. How can I distribute or backup macros / customizations?
http://word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm
http://addbalance.com/word/movetotemplate.htm

5. What is an MVP?
http://www.mvps.org/word/AboutMVPs/index.html and
http://addbalance.com/word/mvp.htm

6. I need to make a form to...

Userforms are custom dialog boxes written using vba.
If you want a fill-in-the-blanks form you want what Word
calls an online form. Look in Word's help for that,
and for more info on online forms follow the links at:
http://addbalance.com/word/wordwebresources.htm#Forms
especially Dian Chapman's series of articles

If you want a custom dialog box that you code with VBA commands
you want a UserForm. Take a look at:
http://www.mvps.org/word/FAQs/Userforms.htm

7. Where can I find more information on the Web?
http://addbalance.com/word/wordwebresources.htm#webvba
http://www.mvps.org/word/FAQs/MacrosVBA.htm
http://www.mvps.org/word/FAQs/Userforms.htm
http://www.mvps.org/word/FAQs/Customization.htm
http://www.mvps.org/word/FAQs/OfficeInterdev.htm

8. Recorded macros...
http://word.mvps.org/FAQs/MacrosVBA/UsingRecorder.htm
How do I edit or change?
http://word.mvps.org/FAQs/MacrosVBA/ModifyRecordedMacro.htm
Recorded macros are usually inefficient and sometimes just
plain don't work. Nevertheless, they often do work and can
be a good place to start!

9. How can I enter something once in a document and have it repeat
elsewhere? (Not really vba, but it keeps being asked.)
http://gregmaxey.mvps.org/Repeating_Data.htm

10. I can't save my customizations - AutoText, menus, etc.
Can't save normal.dot...
If you have Adobe Acrobat 7 installed see the last section of
http://www.gmayor.com/lose_that_adobe_acrobat_toolbar.htm.
Otherwise, hold down the Shift key when selecting the File
menu and select Save All.

11. How can I get a template to show up under a tab with
File => New?
What are templates? Global templates? Document templates?
http://addbalance.com/usersguide/templates.htm


Comments / corrections / additions may be sent to
***@no.spam.addbalance.com. Remove no.spam from the
address. (This is a "proofed" email address, I hope.)

Posted 25 November 2005

Charles Kenyon (the editor)

Loading...