View Single Post
 
Old 09-21-2017, 02:32 AM
Debaser's Avatar
Debaser Debaser is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

You should be using your wkbook variable and not ActiveWorkbook, and you should specify the file format as well:

Code:
          wkbook.SaveAs FileName:=fileToSaveAs, FileFormat:=56, Password:="ANTHEM"
          wkbook.Close
Reply With Quote