Application.DisplayAlerts = False Application.EnableEvents = False ActiveWorkbook.SaveAs Filename:= _ "F:\buying\catalog production\2013\" & FName & ".xlsx", FileFormat:=xlOpenXMLWorkbook, ReadOnlyRecommended:=False, CreateBackup:=False Application.EnableEvents = True Application.DisplayAlerts = True
|Generating a graph via Excel||3||27|
|Excel Conditional Formatting in a Macro||4||26|
|Why doesn't duplicate values work on this spreadsheet?||6||36|
|Google Sheets - Artificial Intelligence||2||20|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!