Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-03-2015, 07:07 PM
Guessed's Avatar
Guessed Guessed is offline HOW TO: Create an auto generated number format for saving templates Windows 7 32bit HOW TO: Create an auto generated number format for saving templates Office 2010 32bit
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,159
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I agree with Charles that this is not a trivial task.

In order for Word to work out what is the next number, you would need to determine how this might be done. You could possibly do it by using:


- an ini file on the network which is updated everytime someone saves a new doc
- a 'correspondence database' which tracks documents and may not be restricted to just storing a document number
- a file search to check on a folder and work out how many existing files are there or which one is has the highest number.

The macros would need to take into account a number of business rules such as:
- how do we decide to create a numbered document or not
- where should documents be saved
- what happens if a document is created and then later deleted (is that number reused or quarantined)
- when is the number created (at creation, at first save, at release of doc)
- if a document is SavedAs to create a new one, does it use a new number or a variant of the previous number (and how does the macro get triggered)
- what happens when a user creates a file offline and needs to add it to the numbering system
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Tags
auto generate, kb, saving



Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW TO: Create an auto generated number format for saving templates How to format a TOC (level 1) using a number, but have the number hidden in the text porpoiseoil Word 1 09-13-2014 12:53 PM
HOW TO: Create an auto generated number format for saving templates How to create a table with a number of line depending a number entered by user Cellendhyll Word Tables 3 07-10-2014 05:49 AM
HOW TO: Create an auto generated number format for saving templates auto-generated Table of Contents has poor formatting? dylansmith Word 7 11-02-2012 06:55 PM
Downloading & saving templates for my son msaylor Word 2 05-29-2012 05:00 PM
HOW TO: Create an auto generated number format for saving templates Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft