macro to save as without dialog prompt

Hansulet

Board Regular
Joined
Jan 24, 2013
Messages
106
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,485
Office Version
2010
Platform
Windows
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,086,257
Messages
5,388,714
Members
402,137
Latest member
pkulkarni

Some videos you may like

This Week's Hot Topics

Top