![]() |
|
#1
|
|||
|
|||
![]() Quote:
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 ![]() |
#2
|
|||
|
|||
![]() Quote:
|
#3
|
|||
|
|||
![]()
But how does I do it? How will the code look like?
|
#4
|
|||
|
|||
![]()
ActiveWorkbook.SaveCopyAs Filename:="C:\Users\Marius Filtvedt\OneDrive - Omega Industrier AS\1. OMEGA\Omega Østfold\Tilbud kunder\Tilbud Interiør" & "_" & ActiveSheet.Range("D7") & ActiveSheet.Range("XX1") & ".xls"
XX1 or whatever holds your file number |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Show table list by using chek box command and save document on sharepoint by using command button | Zhibek | Word VBA | 3 | 08-16-2018 06:19 PM |
can't remove page break that isn't visible in nonprinted characters | georgiajmj49 | Word | 8 | 07-19-2018 03:27 AM |
Outlook 'Start Page' Command Button | Wobble | Outlook | 0 | 03-31-2015 04:49 AM |
Help with a Command Button | dkohnken | Word VBA | 5 | 03-18-2015 10:13 PM |
Command Button | knp11 | PowerPoint | 2 | 01-18-2015 01:41 PM |