Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-02-2018, 02:34 AM
mfiltvedt84 mfiltvedt84 is offline Remove visible command button when attaching in outlook Windows 10 Remove visible command button when attaching in outlook Office 2016
Novice
Remove visible command button when attaching in outlook
 
Join Date: Sep 2018
Posts: 6
mfiltvedt84 is on a distinguished road
Default


Quote:
Originally Posted by trevorc View Post
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
Reply With Quote
  #2  
Old 10-02-2018, 12:35 PM
trevorc trevorc is offline Remove visible command button when attaching in outlook Windows 7 32bit Remove visible command button when attaching in outlook 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
  #3  
Old 10-02-2018, 02:47 PM
mfiltvedt84 mfiltvedt84 is offline Remove visible command button when attaching in outlook Windows 10 Remove visible command button when attaching in outlook Office 2016
Novice
Remove visible command button when attaching in outlook
 
Join Date: Sep 2018
Posts: 6
mfiltvedt84 is on a distinguished road
Default

Quote:
Originally Posted by trevorc View Post
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?
Reply With Quote
  #4  
Old 10-02-2018, 04:33 PM
trevorc trevorc is offline Remove visible command button when attaching in outlook Windows 7 32bit Remove visible command button when attaching in outlook Office 2013
Competent Performer
 
Join Date: Jan 2017
Posts: 173
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default

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
Reply With Quote
Reply



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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft