Hi Everyone,
Can someone help me to add a password to save a file with. the code I have so far is as follows.
It needs to be saved in this particular folder with a passowrd that I will specify. The password does not change so I have that as part of the macro. The file name can also be todaysfile
![]()
ActiveWorkbook.SaveAs Filename:= _ "Y:\filefolder11\filefolder2\filefolder3\Ifilefolder4\todaysfile.xlsx", FileFormat:= _ xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
Bookmarks