Macro Needs Debug, but worked previously

[JennOlsen]

I have a section of code that is hanging up my macro. I think it's because the file already exists where we want it to save. Can anyone confirm and perhaps suggest how to rewrite the code to overwrite any existing files?

ActiveWorkbook.SaveAs Filename:="\\fs-stor-a\AdminServ\AdminServ-Depts\Pay-Shared\PEOPLESOFT-T&L\RECON\048 Reformatted.xls" _
, FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

I should mention I have a nearly identical macro the runs for a different set of criteria but off the same parent file and the code is identical, with there being an existing file and it seems to be working fine. Is it possible that although the Debug points to this string of code that the problem is actually before this?

[6StringJazzer]

All the parameters on this line of code are static values so it is 99% certain the problem is right here.

What error code and message are shown when you get the debug dialog box?

Is there a possibility that the target file is already open by another user?

Is the ActiveWorkbook when this code is executed the same as the file containing the code?

What is the type of the file being saved? Is the file a .xls file? You might need to use xlExcel8 instead of xlNormal. (I would recommend you save as .xlsx anyway.)