TheWennerWoman
Active Member
- Joined
- Aug 1, 2019
- Messages
- 270
- Office Version
- 365
- Platform
- Windows
VBA Code:
pw = ActiveWorkbook.Worksheets(1).Range("H3").Value
ActiveWorkbook.SaveAs master_folder & "\" & a(i, 1) & "_" & yr & "_" & mth & ".xlsx" Password:=pw
Can anyone see why this isn't working?
If I delete the "Password:=pw" bit the file saves just fine.