Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
adel adel is offline
external usenet poster
 
Posts: 8
Default Can I create sequentially numbered documents on a server?

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
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Jay Freedman Jay Freedman is offline
external usenet poster
 
Posts: 9,854
Default Can I create sequentially numbered documents on a server?

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

  #3   Report Post  
Posted to microsoft.public.word.docmanagement
adel adel is offline
external usenet poster
 
Posts: 8
Default Can I create sequentially numbered documents on a server?

Thank you very much Jay!

"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


  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Hettie Hettie is offline
external usenet poster
 
Posts: 5
Default Can I create sequentially numbered documents on a server?

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


  #5   Report Post  
Posted to microsoft.public.word.docmanagement
Jay Freedman Jay Freedman is offline
external usenet poster
 
Posts: 9,854
Default Can I create sequentially numbered documents on a server?

Item 1: To let multiple people use the template, store it in a network
folder that all can access. I'll assume the folder is called
\\companyserver\publicshare\templates but it could be any valid name like
this, or it could be a folder on a mapped network drive (like N:\templates).
Then each person in their own copy of Word needs to go to Tools Options
File Locations, and modify the "Workgroup templates" location to point to
that shared folder.

This will cause the Purchase Order template -- and any other templates you
store there -- to appear in the list in the File New dialog in Word.
People should use the File New command to create new documents based on
the template. Nobody should actually _open_ the template (from File Open)
unless some change has to be made in the template itself.

Item 2: You need to copy the AutoNew macro code from the article and put it
into the Purchase Order template. Instructions for how to do this are at
http://www.gmayor.com/installing_macro.htm. Then you need to make a few
changes in the code to suit your requirements:

- There are two places in the macro that refer to a file named
"C:\Settings.Txt". In both places, change the path of the file to the same
folder where the template is stored, for example,
"\\companyserver\publicshare\templates\Settings.Tx t". (Don't try to use a
mapped drive path here; it'll cause errors if different people have the
location mapped to different drive letters.)

- Locate the lines of code that say

If Order = "" Then
Order = 1

and change them to

If Order = "" Then
Order = 1050

to start the numbering where you want.

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

Hettie wrote:
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.





  #6   Report Post  
Posted to microsoft.public.word.docmanagement
Hettie Hettie is offline
external usenet poster
 
Posts: 5
Default Can I create sequentially numbered documents on a server?

Thank you, I am really close, I just need to make a few adjustments. Have a
great day. You I have certainly made my day. I have been trying to do this
for two days now.

Hettie

"Jay Freedman" wrote:

Item 1: To let multiple people use the template, store it in a network
folder that all can access. I'll assume the folder is called
\\companyserver\publicshare\templates but it could be any valid name like
this, or it could be a folder on a mapped network drive (like N:\templates).
Then each person in their own copy of Word needs to go to Tools Options
File Locations, and modify the "Workgroup templates" location to point to
that shared folder.

This will cause the Purchase Order template -- and any other templates you
store there -- to appear in the list in the File New dialog in Word.
People should use the File New command to create new documents based on
the template. Nobody should actually _open_ the template (from File Open)
unless some change has to be made in the template itself.

Item 2: You need to copy the AutoNew macro code from the article and put it
into the Purchase Order template. Instructions for how to do this are at
http://www.gmayor.com/installing_macro.htm. Then you need to make a few
changes in the code to suit your requirements:

- There are two places in the macro that refer to a file named
"C:\Settings.Txt". In both places, change the path of the file to the same
folder where the template is stored, for example,
"\\companyserver\publicshare\templates\Settings.Tx t". (Don't try to use a
mapped drive path here; it'll cause errors if different people have the
location mapped to different drive letters.)

- Locate the lines of code that say

If Order = "" Then
Order = 1

and change them to

If Order = "" Then
Order = 1050

to start the numbering where you want.

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

Hettie wrote:
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.




  #7   Report Post  
Posted to microsoft.public.word.docmanagement
Hettie Hettie is offline
external usenet poster
 
Posts: 5
Default Can I create sequentially numbered documents on a server?

I am still having difficutly. I am pasting what I have as the macro, can you
tell me if you see anything wrong? I have it saved under Templates on our G:
drive which all employees can access. I know I must be missing something.

Private Sub Document_New()

End Sub
'
' Sub AutoNew()
'Order= System.PrivateString("G:\Templates","macrosetting" ,"order")
If Order = "" Then
Order = 1050
System.PrivateProfileString("G:\Templates", "MacroSettings", "Order") =
OrderActiveDocument.Bookmarks("Order").Range.Inser tBeforeFormat(Order, "00#")
ActiveDocument.SaveAsFileName = "path" & Format(Order, "00#")

End Sub

Sub AutoNew()
'
' AutoNew Macro
' Macro created 8/4/2006 by ihadmin
'

End Sub

"Jay Freedman" wrote:

Item 1: To let multiple people use the template, store it in a network
folder that all can access. I'll assume the folder is called
\\companyserver\publicshare\templates but it could be any valid name like
this, or it could be a folder on a mapped network drive (like N:\templates).
Then each person in their own copy of Word needs to go to Tools Options
File Locations, and modify the "Workgroup templates" location to point to
that shared folder.

This will cause the Purchase Order template -- and any other templates you
store there -- to appear in the list in the File New dialog in Word.
People should use the File New command to create new documents based on
the template. Nobody should actually _open_ the template (from File Open)
unless some change has to be made in the template itself.

Item 2: You need to copy the AutoNew macro code from the article and put it
into the Purchase Order template. Instructions for how to do this are at
http://www.gmayor.com/installing_macro.htm. Then you need to make a few
changes in the code to suit your requirements:

- There are two places in the macro that refer to a file named
"C:\Settings.Txt". In both places, change the path of the file to the same
folder where the template is stored, for example,
"\\companyserver\publicshare\templates\Settings.Tx t". (Don't try to use a
mapped drive path here; it'll cause errors if different people have the
location mapped to different drive letters.)

- Locate the lines of code that say

If Order = "" Then
Order = 1

and change them to

If Order = "" Then
Order = 1050

to start the numbering where you want.

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

Hettie wrote:
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.




  #8   Report Post  
Posted to microsoft.public.word.docmanagement
Jay Freedman Jay Freedman is offline
external usenet poster
 
Posts: 9,854
Default Can I create sequentially numbered documents on a server?

You have too many "Sub" and "End Sub" lines. You should only have one
of each, with Sub AutoNew() at the beginning and with End Sub at the
end. You've commented out (that is, made useless) some important
lines, and you're also missing a couple of lines. It's a mess. :-)

The whole macro should look like this. Delete everything you have now,
and cut and paste the following code without changing anything.

'-------------------------------
Sub AutoNew()

Order = System.PrivateProfileString("G:\Templates\Settings .Txt", _
"MacroSettings", "Order")

If Order = "" Then
Order = 1050
Else
Order = Order + 1
End If

System.PrivateProfileString("G:\Templates\Settings .txt", _
"MacroSettings", "Order") = Order

ActiveDocument.Bookmarks("Order").Range.InsertBefo re _
Format(Order, "00#")
ActiveDocument.SaveAs FileName:="path" & Format(Order, "00#")

End Sub
'-------------------------------

Finally, don't forget to insert a bookmark named "Order" in the body
of the template where you want the number to be inserted, as described
in the article.

--
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 Fri, 4 Aug 2006 14:57:01 -0700, Hettie
wrote:

I am still having difficutly. I am pasting what I have as the macro, can you
tell me if you see anything wrong? I have it saved under Templates on our G:
drive which all employees can access. I know I must be missing something.

Private Sub Document_New()

End Sub
'
' Sub AutoNew()
'Order= System.PrivateString("G:\Templates","macrosetting" ,"order")
If Order = "" Then
Order = 1050
System.PrivateProfileString("G:\Templates", "MacroSettings", "Order") =
OrderActiveDocument.Bookmarks("Order").Range.Inse rtBeforeFormat(Order, "00#")
ActiveDocument.SaveAsFileName = "path" & Format(Order, "00#")

End Sub

Sub AutoNew()
'
' AutoNew Macro
' Macro created 8/4/2006 by ihadmin
'

End Sub

"Jay Freedman" wrote:

Item 1: To let multiple people use the template, store it in a network
folder that all can access. I'll assume the folder is called
\\companyserver\publicshare\templates but it could be any valid name like
this, or it could be a folder on a mapped network drive (like N:\templates).
Then each person in their own copy of Word needs to go to Tools Options
File Locations, and modify the "Workgroup templates" location to point to
that shared folder.

This will cause the Purchase Order template -- and any other templates you
store there -- to appear in the list in the File New dialog in Word.
People should use the File New command to create new documents based on
the template. Nobody should actually _open_ the template (from File Open)
unless some change has to be made in the template itself.

Item 2: You need to copy the AutoNew macro code from the article and put it
into the Purchase Order template. Instructions for how to do this are at
http://www.gmayor.com/installing_macro.htm. Then you need to make a few
changes in the code to suit your requirements:

- There are two places in the macro that refer to a file named
"C:\Settings.Txt". In both places, change the path of the file to the same
folder where the template is stored, for example,
"\\companyserver\publicshare\templates\Settings.Tx t". (Don't try to use a
mapped drive path here; it'll cause errors if different people have the
location mapped to different drive letters.)

- Locate the lines of code that say

If Order = "" Then
Order = 1

and change them to

If Order = "" Then
Order = 1050

to start the numbering where you want.

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

Hettie wrote:
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.




  #9   Report Post  
Posted to microsoft.public.word.docmanagement
Patty Patty is offline
external usenet poster
 
Posts: 31
Default It worked, but...

Jay,
I followed your instructions and added your code to my macro to make a new
number sequentially appear on my new PO, however the template that I used has
a [100] and my new number appears before it. How do I get rid of the [100]
from the original template?
Thanks-
Pat

"Jay Freedman" wrote:

Item 1: To let multiple people use the template, store it in a network
folder that all can access. I'll assume the folder is called
\\companyserver\publicshare\templates but it could be any valid name like
this, or it could be a folder on a mapped network drive (like N:\templates).
Then each person in their own copy of Word needs to go to Tools Options
File Locations, and modify the "Workgroup templates" location to point to
that shared folder.

This will cause the Purchase Order template -- and any other templates you
store there -- to appear in the list in the File New dialog in Word.
People should use the File New command to create new documents based on
the template. Nobody should actually _open_ the template (from File Open)
unless some change has to be made in the template itself.

Item 2: You need to copy the AutoNew macro code from the article and put it
into the Purchase Order template. Instructions for how to do this are at
http://www.gmayor.com/installing_macro.htm. Then you need to make a few
changes in the code to suit your requirements:

- There are two places in the macro that refer to a file named
"C:\Settings.Txt". In both places, change the path of the file to the same
folder where the template is stored, for example,
"\\companyserver\publicshare\templates\Settings.Tx t". (Don't try to use a
mapped drive path here; it'll cause errors if different people have the
location mapped to different drive letters.)

- Locate the lines of code that say

If Order = "" Then
Order = 1

and change them to

If Order = "" Then
Order = 1050

to start the numbering where you want.

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

Hettie wrote:
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.




  #10   Report Post  
Posted to microsoft.public.word.docmanagement
Hettie Hettie is offline
external usenet poster
 
Posts: 5
Default Can I create sequentially numbered documents on a server?

I am working on a Purchase order form as well, but I can't get my number to
increase. I followed the directions on how to do it, but I must be doing
something wrong. Can you help?

Hettie

"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



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I generate a document number for documents on my server? bkllplaw Microsoft Word Help 5 February 9th 06 01:24 PM
Create multiple documents from one and vice versa Village Idiot Dan Microsoft Word Help 7 October 24th 05 02:27 PM
Cannot create new documents in Word or edit existing documents. EGerbil Microsoft Word Help 7 August 31st 05 05:03 AM
duplex printing page numbered documents Ruth Microsoft Word Help 1 August 17th 05 01:31 PM
How do I create an outline with numbered headings in Word? Dave Plyer Microsoft Word Help 2 April 17th 05 11:00 PM


All times are GMT +1. The time now is 01:54 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"