macro to save as without dialog prompt

Hansulet

Board Regular
Joined
Jan 24, 2013
Messages
97
I have a VBA code to save as my file in other location but I need an improvement to save as my file without dialog prompt

ActiveWorkbook.SaveAs Filename:="C:\Users\alex-cccp\Desktop" & ActiveWorkbook.Name, FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False
Application.DisplayAlerts = False
 

yky

Well-known Member
Joined
Jun 7, 2011
Messages
1,445
Code:
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:="C:\Users\alex-cccp\Desktop" & ActiveWorkbook.Name, FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False
Application.DisplayAlerts = True
 

Forum statistics

Threads
1,078,309
Messages
5,339,410
Members
399,302
Latest member
Swiftymj

Some videos you may like

This Week's Hot Topics

Top