View Single Post
  #8   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

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