automatic document saving in VBA upon closing

[DaffyDukk]

I am trying to eliminate user interaction when naming documents that need to be saved. Basically, I need to know the coding that will enable me to be able to save a document automatically, giving it the file name of 'time and date', and specifying where the file will be saved as well. I am almost there I think, I can get the document to bring up the Save As dialogue box, but I can't quite get to the next stage, and I am unsure if I am going about this in the right way! Thanks in advance for your help.

 

[JustinEzequiel]

For saving a Word document:

Sub test()
Dim oDoc As Document
Dim sFile As String
Dim sLoc As String

sLoc = "C:\TEMP\"

sFile = sLoc & Format$(Now, "YYYYMMDDHHNNSS&quot & ".doc"

Set oDoc = ActiveDocument
oDoc.SaveAs FileName:=sFile
oDoc.Close
Set oDoc = Nothing
End Sub

For an Excel workbook, change
Dim oDoc As Document
to
Dim oDoc As Workbook