May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.
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.
|Modify Text File with Excel Macro||13||51|
|why PtrSafe before Function on 64bit does not fix the APIs?||2||30|
|Excel not storing numeric string correctly||5||43|
|Save PowerPoint from Active Workbook Excel VBA||5||38|
Join the community of 500,000 technology professionals and ask your questions.