Quote:
Originally Posted by mfiltvedt84
Ok.
Another problem.
When om saving my file with savecopyas the Template im saving can sometimes be to the same customer but different offer. How will my code look like to add a -1 or something on filename when saving...? Where to put it? When everytime I write offer to the same customer it shallautomatically add 1, then 2 and so on.. help 
|
You already have your answer above, this is what you do for that as well. Keep a record on your sheet of the last used number and add this to the file name as you have done for whatever you have in D7... & ActiveSheet.Range("D7") &