View Single Post
 
Old 10-02-2018, 12:35 PM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
 
Join Date: Jan 2017
Posts: 173
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default

Quote:
Originally Posted by mfiltvedt84 View Post
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") &
Reply With Quote