How do I set up automatic numbering?

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

Guest

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
 
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
 
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




--------- --------- --------- --------- --------- ---------
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.
 
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
 
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
 
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/VBABasicsIn15Mins.htm
http://word.mvps.org/FAQs/MacrosVBA/UsingRecorder.htm
http://word.mvps.org/FAQs/Customization/AsgnCmdOrMacroToToolbar.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




--------- --------- --------- --------- --------- ---------
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.
 
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/VBABasicsIn15Mins.htm
http://word.mvps.org/FAQs/MacrosVBA/UsingRecorder.htm
http://word.mvps.org/FAQs/Customization/AsgnCmdOrMacroToToolbar.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




--------- --------- --------- --------- --------- ---------
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.
 
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
 
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
 
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




--------- --------- --------- --------- --------- ---------
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.
 
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




--------- --------- --------- --------- --------- ---------
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,

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,

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!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top