I have the following code in a macro, and it worked once, and now will not. Can anyone offer a suggestion? I appreciate any help.
ActiveWorkbook.SaveAs _
FileName:="D:Personal" & Worksheets("Instructions") _
.Range("DIVLOC").Value & "I.xls", _
FileFormat:=xlNormal, _
Password:="mfgie", _
WriteResPassword:=""
ActiveWorkbook.SaveAs _
FileName:="D:Personal" & Worksheets("Instructions") _
.Range("DIVLOC").Value & "I.xls", _
FileFormat:=xlNormal, _
Password:="mfgie", _
WriteResPassword:=""