Can you show me an actual example of how the formula should work. I am very
new with macros and don't understand the direction to the link below. I have
a Purchase Order document in Word that is a template. I need to be able to
start at 1050 and have the number increase each time I open it. I will need
multiple people to be able to access this document from our company server.
Can you help?
"Jay Freedman" wrote:
I assume you're using a solution like the one in
http://www.word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm, where the
current number is held in an external settings file ("C:\Settings.Txt"
is the name used in that article).
The solution I suggest is that you create a separate settings file for
each type of purchase order. Then in each template, include the name
of the corresponding settings file. So, for instance, the template
used to make Admin P.O.s would have its AutoNew macro work on
AdminSettings.txt, while the one for Marketing P.O.s would work on
MarketingSettings.txt.
There is an alternative that uses a single settings file containing
different numbers for different templates. In this scheme, the file
name is the same in all templates, but each template uses a different
name in place of the "MacroSettings" parameter. (Within the settings
file, this becomes a label for a section of the settings. That happens
automatically.)
A final point: If multiple users will be creating P.O.s from these
templates, the settings file(s) should be on the server rather than on
a single workstation. This is mentioned, but not prominently, in the
article: "if more than one user needs access to the up-to-date number,
a text file can be saved in a shared area on the network." To make
this work, the file name in the AutoNew macros must contain the path
to the share instead of "C:\...".
--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.
On Wed, 26 Jul 2006 13:56:01 -0700, adel
wrote:
Hi,
I have created Purchase Order word documents which I would like to put on
our server. Each department's template is ready and I have used the Autonew
macro to add sequential number to the P.O.s (everything is working fine on
my computer) Now, my problem is that whatever template I am opening when
working on the server, it does not differentiate the different P.O.s For
example, I have an Admin P.O. #3, and if I want to open the Marketing P.O.
for the first time, instead of having P.O. #1 I have P.O. #4.
Would you know how to solve that problem?
Thank you very much for your help.
Adel