It was'nt in my Templates folder because I was testing it out before I put it
on my Server which is where I store all my templates related to my business.
I tried to preset the start number to the next one that we need
(i.e."2007100#") but it did not open a successive number it opened a document
with a number 2007100120071001. The same thing happened when I had only the
three digit number 001 turned into 001001 and it was that way on each one I
opened.
"Jay Freedman" wrote:
Did you set up the macro in a template stored in your Templates
folder? Word really doesn't like macros in documents, or in templates
that aren't in the Templates folder, because that's a favorite way to
spread macro viruses.
Assuming it is in a template, go to Tools Macro Security and set
the security level to Medium. On the second tab of the dialog, check
the box for "Trust all installed templates and add-ins". That should
make sure the macros are enabled.
The number-format pattern will work with eight digits; just change it
to "0000000#".
On Fri, 5 Oct 2007 16:08:01 -0700, snulton
wrote:
I have set up the Macro as on the page however when I attempt to open the
template Microsoft Basic pops up with the messege "The macros in this project
are disabled. Please refer to the online help or documentation of the host
application to determine how to enable macros." then I got a popup trying to
debug the first of the last two commands.
Also is the value "00#" a locked in numeric value or will it work with eight
digits?
"Jay Freedman" wrote:
snulton wrote:
I have a template that has a space for a number. I want each
successive document opened using that template to have a new number
that is the next number in sucession, i.e. - after opening 20071001,
the next time that I access that template should open 2001002.
See http://www.word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm.
--
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.