PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
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 ")
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.