Ready to get started with anonymous questions today? It's easy! Learn more.
myDirECTorY = "C:\temp\" 'Wherever you want myFileNameO = myDirECTorY & Format(Now(), "yyyymmdd_hhmm") & " report" & ".xlsx" Workbooks.Add ActiveSheet.Paste ActiveWorkbook.SaveAs Filename:=myFileNameO, FileFormat:= _ xlOpenXMLWorkbook, CreateBackup:=False ActiveWorkbook.Close
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.