All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.
myDirECTorY = "C:\_SAP\ShortageRpt\DefaultExtractFiles\" 'Wherever you want 'myFileNameO = myDirECTorY & Format(Now(), "yyyymmdd_hhmm") & " ZSHORTV2DataCurrent" & ".xlsx" 'File name as desired. myFileNameO = myDirECTorY & " ZSHORTV2DataCurrent" & ".txt" 'File name as desired. Workbooks.Add ActiveSheet.Paste 'Add text to column here ActiveWorkbook.SaveAs Filename:=myFileNameO, FileFormat:= _ xlOpenXMLWorkbook, CreateBackup:=False ActiveWorkbook.Close MsgBox (" Done file saved ")
|Excel 2016 VBA - userform and z-Order of controls||11||33|
|Conditional format Excel Cell||3||17|
|How to highlight the first row in a different color without knowing how many columns beforehand in vb.net||6||30|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!