Hopefully, final posting with the correct info

Application.DisplayAlerts = False

ActiveWorkbook.SaveAs Filename:= _
NewPO_No _
, FileFormat:=xlExcel8, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

Application.DisplayAlerts = True

That is how it should be.

--
__________________________________
HTH

Bob

"LA-Alc" wrote in message
...
Ahhh, that would make more sense.

Thanks for the help Bob, appreciate it!

"Bob Phillips" wrote:

That should have been

Application.DisplayAlerts = True


--
__________________________________
HTH

Bob

"LA-Alc" wrote in message
...
Hi Bob,

Thanks for the check. The code that I'm using is:

ActiveWorkbook.SaveAs Filename:= _
NewPO_No _
, FileFormat:=xlExcel8, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
Application.DisplayAlerts = False

When I run this, the message still comes up. Doing a bit of searching
I'm
not sure if I should be addressing the ConflictResolution parameter of
the
save? Yours works, so maybe it's more my code than anything else.

Thanks again.

"Bob Phillips" wrote:

That is odd, I just tried it and it works fine.

--
__________________________________
HTH

Bob