![]() |
|
#1
|
|||
|
|||
|
So i was looking through the forum and a total newbie to advance stuff with office. I found this but not sure what to do to edit it for my needs.
Code:
Private Sub Document_New()
Dim StrName As String, StrDefPath As String, StrTmpPath As String
StrName = Environ("UserName") & Format(Now, "YYYYMMDD")
StrTmpPath = "Filepath for documents based on this template"
StrDefPath = Options.DefaultFilePath(wdDocumentsPath)
Options.DefaultFilePath(wdDocumentsPath) = StrTmpPath
With Application.Dialogs(wdDialogFileSaveAs)
.Name = StrName
.Show
End With
Options.DefaultFilePath(wdDocumentsPath) = StrDefPath
End Sub
ex. One of the lines in the form is Residence: So would like when they press the save button it would save the file as Residence Date.doc Can this be down and for the path's do I put in the actual path like c:\user\temp\Documents\forms Thanks in advance Last edited by macropod; 03-22-2013 at 10:12 PM. Reason: Added code tags & formatting |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Command button - save in temp folder and send email with attachment
|
bigbird69 | Word VBA | 13 | 11-18-2012 10:06 PM |
Command Button will not work when document is protected
|
brockjensen | Word | 1 | 11-02-2012 06:59 PM |
| Word ask to save template whenever i save a derived document | jorbjo | Word | 3 | 10-04-2012 10:52 AM |
Adding email button to Word form
|
leilers | Word | 5 | 01-09-2012 03:21 PM |
| Adding an Email Button to a Word Document | maddoktor | Word | 0 | 12-01-2011 01:32 PM |