Inside excel's VBA, I'd do this:

application.displayalerts = false
myworkbook.saveas ....
application.displayalerts = true



Maury Markowitz wrote:

I have an Access VBA script that uses XL to create a small workbook and then
save it. It is not uncommon to run it a couple of times a day, but every time
we do it puts up a dialog asking if you want to overwrite it?

Is there any way to turn this off? Is ConflicResoution the way? It doesn't
seem to be. If it is, how do I decode the enum into a real int value?

Maury

--

Dave Peterson