LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
User form and Command button Marilyn Excel Discussion (Misc queries) 3 May 9th 07 12:50 AM
Trouble with saving user input in an Excel Form. University of Maine student Excel Discussion (Misc queries) 0 March 14th 06 07:31 PM
Command Button on User form for Printing Anthony Slater Excel Discussion (Misc queries) 2 September 7th 05 02:01 PM
Open an Outlook folder when a user clicks on a command button ... Rob Keel Excel Discussion (Misc queries) 2 August 1st 05 08:23 AM
User defined file name in an OpenText File command surveyorinva Excel Programming 1 June 8th 04 06:40 PM


All times are GMT +1. The time now is 08:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"