Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
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
|Concatenate strings with original parameters||21||41|
|Move data from one sheet to another||11||30|
|Excel VBA - macro in one workbook with another open||4||19|
|which one of the last argument of YEARFARCis correct to use||5||23|