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
|Generating a graph via Excel||3||28|
|Copy value from a certain cell||5||25|
|Sum iF based on a null cell||11||29|
|VBA to get the value of specific based on Row and Column ID||7||23|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!