![]() |
|
#1
|
|||
|
|||
![]()
This is EXACTLY what I was looking for !!
Thank you very much. My macros are: Sub AutoClose() ' ' When closing document, saves with original name + location, ' then to D:\reservekopie\finalcopy+date+time ' ' Dim strPath, strFile As String strPath = "D:\reservekopie" 'set path strFile = "finalcopy_" 'set filename ActiveDocument.Save ActiveDocument.SaveAs FileName:=strPath & strFile & _ Format((Date), " ddMMMMyyyy ") & Format((Time), "HHumm") ActiveWindow.Close Selection.HomeKey Unit:=wdLine WordBasic.DisableAutoMacros 0 'Enables Auto Macros End Sub Sub Sparecopy() ' ' makes copy of content, saves to D:\reservekopie\workingcopy+date+time ' ' WordBasic.DisableAutoMacros 1 'Disables Auto Macros Dim strPath, strFile As String Selection.WholeStory Selection.Copy Documents.Add Template:="Normal", NewTemplate:=False, DocumentType:=0 Selection.PasteAndFormat (wdFormatOriginalFormatting) strPath = "D:\reservekopie" 'set path strFile = "workingcopy" 'set filename ActiveDocument.SaveAs FileName:=strPath & strFile & _ Format((Date), " ddMMMMyyyy ") & Format((Time), "HHumm") & Format(Order, "_00#") ActiveWindow.Close Selection.HomeKey Unit:=wdLine WordBasic.DisableAutoMacros 0 'Enables Auto Macros End Sub |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create a macro to autosave a file every 5 minutes and up-rev the filename | SPJSPENCER | Word VBA | 3 | 12-12-2019 11:55 AM |
![]() |
get4hari | Excel Programming | 8 | 09-26-2015 10:33 PM |
VBA Code to create a Macro | Shazz | Outlook | 0 | 03-10-2015 09:52 AM |
![]() |
rsrasc | Word VBA | 5 | 11-16-2014 05:47 AM |
Need Macro code for Outlook | gbaker | Outlook | 0 | 04-11-2013 10:29 AM |