A
Andy
Hi Al
I have a template which i have managed to set up through the template wizard and data tracking add-inn. This saves certain fields from the template into a excel file, which works fine. I want the template to load up with a number 1 up from the previous time so that each time the form is used, it has it's own i.d number. Also i want it to be saved as that i.d number automaticaly when the save button is clicked, so that the template is not overwritten and a copy of each of these forms is kept in a specific folder! I have seen a few ideas on vba suggestions that seem to work for others, but don't on mine. May be because it is a template or because of the data tracker??
Any ideas?
Appreciate any help you can give
I have a template which i have managed to set up through the template wizard and data tracking add-inn. This saves certain fields from the template into a excel file, which works fine. I want the template to load up with a number 1 up from the previous time so that each time the form is used, it has it's own i.d number. Also i want it to be saved as that i.d number automaticaly when the save button is clicked, so that the template is not overwritten and a copy of each of these forms is kept in a specific folder! I have seen a few ideas on vba suggestions that seem to work for others, but don't on mine. May be because it is a template or because of the data tracker??
Any ideas?
Appreciate any help you can give