Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a file from a command button with user input
'Try This...
Sub SaveName() Dim strPath As String Dim strFile As String Dim strDate As String strPath = "C:\Temp" strFile = Sheet1.Range("I3") strDate = Format(Now(), "mm-dd-yyyy") ActiveWorkbook.SaveAs FileName:=strPath & "\" & strFile & strDate & ".xls" End Sub -----Original Message----- An easy one for excel experts! 1. I need to save a file from a command button with the current date attached at the end? Command Button is written part is already complete. 2. I would like the name the file to be entered into a cell, say I3. I want the button to use the name in the cell, (I3), and then add the date proir to saving the file. Can any one help! . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User form and Command button | Excel Discussion (Misc queries) | |||
Trouble with saving user input in an Excel Form. | Excel Discussion (Misc queries) | |||
Command Button on User form for Printing | Excel Discussion (Misc queries) | |||
Open an Outlook folder when a user clicks on a command button ... | Excel Discussion (Misc queries) | |||
User defined file name in an OpenText File command | Excel Programming |