Getting rid of excel message after quiting excel

  • Thread starter Thread starter Wilco Morren
  • Start date Start date
W

Wilco Morren

L.S.,

Via Oracle I save an excel-file to a text (txt) file. In
the Oracle-code I want to automatically close Excel, but
the message:
'test.txt is not in Microsoft97-format. Do you want to
save your changes? bla bla bla.'

Is there a way this message can be skipped? The same for
the message 'test.txt already exists. Overwrite file?'.

Hope anyone can help me!

Wilco Morren
 
Hi Wilco

Application.DisplayAlerts = False
is the standard way, assuming you are talking Excel VBA code. Hope it translates to "Oracle code" one way or another.
 
Back
Top