Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I set up automatic numbering?
Hi,
I am creating a Purchase Order template, and would like the P.O. number to be updated automatically every time I open the document. I have no idea how to do that. Please let me know if you can help me. Thank you |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I set up automatic numbering?
Hi Adel
adel wrote: I am creating a Purchase Order template, and would like the P.O. number to be updated automatically every time I open the document. Creating sequentially numbered documents (such as invoices, by Doug Robbins) http://word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm Greetings Robert -- /"\ ASCII Ribbon Campaign | MS \ / | MVP X Against HTML | for / \ in e-mail & news | Word |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I set up automatic numbering?
http://word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm
-- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message ... Hi, I am creating a Purchase Order template, and would like the P.O. number to be updated automatically every time I open the document. I have no idea how to do that. Please let me know if you can help me. Thank you |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I set up automatic numbering?
Thank you Charles for your help. The thing is I have tried this morning
because had seen this link in previous questions, but did not manage to do it. Would you have by any chance an easier or a step by step explanation of the process. Thank you. Adeline "Charles Kenyon" wrote: http://word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message ... Hi, I am creating a Purchase Order template, and would like the P.O. number to be updated automatically every time I open the document. I have no idea how to do that. Please let me know if you can help me. Thank you |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I set up automatic numbering?
Sorry, I do not. What is causing you problems?
-- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message ... Thank you Charles for your help. The thing is I have tried this morning because had seen this link in previous questions, but did not manage to do it. Would you have by any chance an easier or a step by step explanation of the process. Thank you. Adeline "Charles Kenyon" wrote: http://word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message ... Hi, I am creating a Purchase Order template, and would like the P.O. number to be updated automatically every time I open the document. I have no idea how to do that. Please let me know if you can help me. Thank you |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I set up automatic numbering?
Good morning Charles,
Actually, I am not familiar with either VBA or macros in Word. I have tried both and in VBA it doesn't do anything but my question is should I create an AutoNew macro or a AutoOpen with all the language? What is th easier way to do it? Should the P.O. number be pudated each time I open the document? Thank you very much for your help and sorry for the delay in answering. Adeline "Charles Kenyon" wrote: Sorry, I do not. What is causing you problems? -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message ... Thank you Charles for your help. The thing is I have tried this morning because had seen this link in previous questions, but did not manage to do it. Would you have by any chance an easier or a step by step explanation of the process. Thank you. Adeline "Charles Kenyon" wrote: http://word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message ... Hi, I am creating a Purchase Order template, and would like the P.O. number to be updated automatically every time I open the document. I have no idea how to do that. Please let me know if you can help me. Thank you |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I set up automatic numbering?
Put it in a template as an AutoNew macro. Users start a new document using:
File New and picking your template. A macro is visual basic for applications (vba). The number should be updated each time you create a new purchase order, not each time you look at an existing one, I suspect. I can't teach you the ins and outs of programming long distance. Here are some links to get you started: http://word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm http://word.mvps.org/FAQs/MacrosVBA/...csIn15Mins.htm http://word.mvps.org/FAQs/MacrosVBA/UsingRecorder.htm http://word.mvps.org/FAQs/Customizat...oToToolbar.htm I got those links from http://word.mvps.org/FAQs/MacrosVBA/index.htm. If you need more, see that page and http://addbalance.com/word/wordwebresources.htm#webvba. -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message news Good morning Charles, Actually, I am not familiar with either VBA or macros in Word. I have tried both and in VBA it doesn't do anything but my question is should I create an AutoNew macro or a AutoOpen with all the language? What is th easier way to do it? Should the P.O. number be pudated each time I open the document? Thank you very much for your help and sorry for the delay in answering. Adeline "Charles Kenyon" wrote: Sorry, I do not. What is causing you problems? -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message ... Thank you Charles for your help. The thing is I have tried this morning because had seen this link in previous questions, but did not manage to do it. Would you have by any chance an easier or a step by step explanation of the process. Thank you. Adeline "Charles Kenyon" wrote: http://word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message ... Hi, I am creating a Purchase Order template, and would like the P.O. number to be updated automatically every time I open the document. I have no idea how to do that. Please let me know if you can help me. Thank you |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I set up automatic numbering?
Great Charles, I finally had it worked. Now my question is:
How do I do to restart the numbering to 1? I am going to send individualized template to other employees, will the document be updated automatically when they open it? Thank you very much. Adeline "Charles Kenyon" wrote: Put it in a template as an AutoNew macro. Users start a new document using: File New and picking your template. A macro is visual basic for applications (vba). The number should be updated each time you create a new purchase order, not each time you look at an existing one, I suspect. I can't teach you the ins and outs of programming long distance. Here are some links to get you started: http://word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm http://word.mvps.org/FAQs/MacrosVBA/...csIn15Mins.htm http://word.mvps.org/FAQs/MacrosVBA/UsingRecorder.htm http://word.mvps.org/FAQs/Customizat...oToToolbar.htm I got those links from http://word.mvps.org/FAQs/MacrosVBA/index.htm. If you need more, see that page and http://addbalance.com/word/wordwebresources.htm#webvba. -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message news Good morning Charles, Actually, I am not familiar with either VBA or macros in Word. I have tried both and in VBA it doesn't do anything but my question is should I create an AutoNew macro or a AutoOpen with all the language? What is th easier way to do it? Should the P.O. number be pudated each time I open the document? Thank you very much for your help and sorry for the delay in answering. Adeline "Charles Kenyon" wrote: Sorry, I do not. What is causing you problems? -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message ... Thank you Charles for your help. The thing is I have tried this morning because had seen this link in previous questions, but did not manage to do it. Would you have by any chance an easier or a step by step explanation of the process. Thank you. Adeline "Charles Kenyon" wrote: http://word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message ... Hi, I am creating a Purchase Order template, and would like the P.O. number to be updated automatically every time I open the document. I have no idea how to do that. Please let me know if you can help me. Thank you |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I set up automatic numbering?
Sorry, we're way over my head here.
It depends on what method you are using. Do your employees have access to whatever the number file is? How are you tracking the numbering? If with a separate file, to restart numbering, you change the number in that file to 0, I expect. There is a difference, a critical difference, between a template and a document. If you use one of the methods set out, and you have an AutoNew macro, that macro will run, and do whatever it does, when a new document is created. It will not run when that same document is later opened. -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message ... Great Charles, I finally had it worked. Now my question is: How do I do to restart the numbering to 1? I am going to send individualized template to other employees, will the document be updated automatically when they open it? Thank you very much. Adeline "Charles Kenyon" wrote: Put it in a template as an AutoNew macro. Users start a new document using: File New and picking your template. A macro is visual basic for applications (vba). The number should be updated each time you create a new purchase order, not each time you look at an existing one, I suspect. I can't teach you the ins and outs of programming long distance. Here are some links to get you started: http://word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm http://word.mvps.org/FAQs/MacrosVBA/...csIn15Mins.htm http://word.mvps.org/FAQs/MacrosVBA/UsingRecorder.htm http://word.mvps.org/FAQs/Customizat...oToToolbar.htm I got those links from http://word.mvps.org/FAQs/MacrosVBA/index.htm. If you need more, see that page and http://addbalance.com/word/wordwebresources.htm#webvba. -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message news Good morning Charles, Actually, I am not familiar with either VBA or macros in Word. I have tried both and in VBA it doesn't do anything but my question is should I create an AutoNew macro or a AutoOpen with all the language? What is th easier way to do it? Should the P.O. number be pudated each time I open the document? Thank you very much for your help and sorry for the delay in answering. Adeline "Charles Kenyon" wrote: Sorry, I do not. What is causing you problems? -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message ... Thank you Charles for your help. The thing is I have tried this morning because had seen this link in previous questions, but did not manage to do it. Would you have by any chance an easier or a step by step explanation of the process. Thank you. Adeline "Charles Kenyon" wrote: http://word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message ... Hi, I am creating a Purchase Order template, and would like the P.O. number to be updated automatically every time I open the document. I have no idea how to do that. Please let me know if you can help me. Thank you |
#10
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I set up automatic numbering?
Charles,
What I am doing is a Purchase Order template for different departments in the company, the template itself being different for each department. Now that I have succeeded in creating the macro with VBA, I would like to be able to restart the numbering at 1 for the template I have already created. As of now, after all my endeavors, I am at number 15... Thank you for your help once again!!! "Charles Kenyon" wrote: Sorry, we're way over my head here. It depends on what method you are using. Do your employees have access to whatever the number file is? How are you tracking the numbering? If with a separate file, to restart numbering, you change the number in that file to 0, I expect. There is a difference, a critical difference, between a template and a document. If you use one of the methods set out, and you have an AutoNew macro, that macro will run, and do whatever it does, when a new document is created. It will not run when that same document is later opened. -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message ... Great Charles, I finally had it worked. Now my question is: How do I do to restart the numbering to 1? I am going to send individualized template to other employees, will the document be updated automatically when they open it? Thank you very much. Adeline "Charles Kenyon" wrote: Put it in a template as an AutoNew macro. Users start a new document using: File New and picking your template. A macro is visual basic for applications (vba). The number should be updated each time you create a new purchase order, not each time you look at an existing one, I suspect. I can't teach you the ins and outs of programming long distance. Here are some links to get you started: http://word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm http://word.mvps.org/FAQs/MacrosVBA/...csIn15Mins.htm http://word.mvps.org/FAQs/MacrosVBA/UsingRecorder.htm http://word.mvps.org/FAQs/Customizat...oToToolbar.htm I got those links from http://word.mvps.org/FAQs/MacrosVBA/index.htm. If you need more, see that page and http://addbalance.com/word/wordwebresources.htm#webvba. -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message news Good morning Charles, Actually, I am not familiar with either VBA or macros in Word. I have tried both and in VBA it doesn't do anything but my question is should I create an AutoNew macro or a AutoOpen with all the language? What is th easier way to do it? Should the P.O. number be pudated each time I open the document? Thank you very much for your help and sorry for the delay in answering. Adeline "Charles Kenyon" wrote: Sorry, I do not. What is causing you problems? -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message ... Thank you Charles for your help. The thing is I have tried this morning because had seen this link in previous questions, but did not manage to do it. Would you have by any chance an easier or a step by step explanation of the process. Thank you. Adeline "Charles Kenyon" wrote: http://word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm -- 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! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- 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. "adel" wrote in message ... Hi, I am creating a Purchase Order template, and would like the P.O. number to be updated automatically every time I open the document. I have no idea how to do that. Please let me know if you can help me. Thank you |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
turn off automatic numbering; keep existing numbering | Microsoft Word Help | |||
How to stop automatic numbering & new line capitalization? | Microsoft Word Help | |||
How can I make automatic numbering us decimal tabs? | Microsoft Word Help | |||
Converting automatic numbering to hard text | Microsoft Word Help | |||
Numbering - skip a level | Microsoft Word Help |