View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
LA-Alc[_2_] LA-Alc[_2_] is offline
external usenet poster
 
Posts: 3
Default Defined Names response

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