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
|