Skip to content

Instantly share code, notes, and snippets.

@imamuddinwp

imamuddinwp/Excel VBA Macro : Save a workbook in a directory with specific name and date

Last active May 14, 2020 03:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save imamuddinwp/cf7cabbeb5f046b3a7653f0d281adeaa to your computer and use it in GitHub Desktop.
Save imamuddinwp/cf7cabbeb5f046b3a7653f0d281adeaa to your computer and use it in GitHub Desktop.
Download ZIP
Hi There!!! Here is the Excel VBA Macro code for Save a workbook in a directory with specific name and date with excel vba macro; powered by Imam Uddin; imamcu07.
Raw
Excel VBA Macro : Save a workbook in a directory with specific name and date
Sub My_operation_name()
'After ending all operations---------
ChDir "D:\ImAmUdDiN\Daily-Report"
ActiveWorkbook.SaveAs Filename:= _
"D:\ImAmUdDiN\Daily-Report\DLS-" & Format(Now(), "DD-MMM-YYYY") & ".xlsx", FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False
ActiveWorkbook.Save
'--------All Done-----------
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment