|
|
#12
10-02-2018, 04:33 PM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| 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 |
Windows 7 32bit 
Office 2013
Threaded Mode