 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / March 2005Saving Macro
I have been asked if it is possible to have a default setting when saving a document. There are wanting the first part of each doc to have the year/month/day then a description of some kind..is there anyway of setting this so it defaults. Mat G'day matthew.rodwell@luptonfawcett.com (mrodwell), Yes, this is possible, but we require much more info on the exact circumstances to offer more detailed help. Steve Hudson - Word Heretic steve from wordheretic.com (Email replies require payment) Without prejudice mrodwell reckoned: >I have been asked if it is possible to have a default setting when >saving a document. There are wanting the first part of each doc to >have the year/month/day then a description of some kind..is there >anyway of setting this so it defaults. > >Mat Hi there Steve....all i want is for when the docs are saved no matter what they are for the date to be placed at the begining of the name, then a part that allows them to place a description of there own. eg. 15/12/04_Letter to Client.doc obvouisly i want it to change with the current date so that people know what day the file was created on.... Mat G'day matthew.rodwell@luptonfawcett.com, In the template for that document type: Public Sub FileSaveAs() 'replace this with your lets make a filename 'and assign a path and Activedocument.SaveAs 'to it MsgBox "yeah" End Sub Assign Ctrl+S in that template to this macro as well. You may also need a Public Sub FileSave() FileSaveAs End Sub Steve Hudson - Word Heretic steve from wordheretic.com (Email replies require payment) Without prejudice matthew.rodwell@luptonfawcett.com reckoned: >Hi there Steve....all i want is for when the docs are saved no matter >what they are for the date to be placed at the begining of the name, [quoted text clipped - 6 lines] > >Mat But which bit adds the auto date the beginning...i need the file name to change as the date changes you see....please help Mat Maybe something like: Sub FileSaveAs() With Dialogs(wdDialogFileSaveAs) .Name = Format(Date, "yyyy mmm dd") .Show End With End Sub Note the date format is 2005 Mar 03. For some reason the format yyyy/mm/dd won't work. Does anyone else know why? Forward and back slashes are reserved characters that are not allowed in filenames. Others include * : ? " < > | It's a hangover from DOS.  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Maybe something like: > [quoted text clipped - 7 lines] > Note the date format is 2005 Mar 03. For some reason the format > yyyy/mm/dd won't work. Does anyone else know why? Graham, Doh! I now have a hand print planted on my forehead :-) Thanks for showing me the forrest while I was tripping over a tree. Thanks you guys that is exactly what i wanted....thanks for your help..can't believe its is so simple
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.