Remove visible command button when attaching in outlook

mfiltvedt84 · #1 10-02-2018, 02:34 AM

Quote:

Originally Posted by trevorc

I should have added that you can use the recorder when you create the command button, to see the VBA code to use for turning the visible property on/off in your code.

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

trevorc · #2 10-02-2018, 12:35 PM

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") &

mfiltvedt84 · #3 10-02-2018, 02:47 PM

Quote:

Originally Posted by trevorc

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") &

But how does I do it? How will the code look like?

trevorc · #4 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