Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) subExportBackup End Sub Public Sub subExportBackup() Dim strTemp As String Dim f As String Dim strFileName As String strFileName = "C:\Program Files\Ent\AutoBackups\" & ActiveWorkbook.Name & "_" & Format(Date, "YYYYMMDD") & " " & Format(Time, "hh.mm.ss") & ".txt" f = strFileName ' this is the file name ActiveWorkbook.SaveAs f End Sub
|Preserving formatting after data refresh in a table in Excel||3||16|
|Select a random value from list and chg background color.||5||23|
|IF OR formula Excel - multiple conditions||9||41|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!