Disabling Excel warning from VBA

[Sylvain Provencher]

I do replace operation in an Excel sheet via Access. When string doesn'y
exist, I got a Warning. I want to disable it (not receiving it). There is a
way ?

I tried to do a find first, but find don't look in first cell of the
sheet... any ideas ?
sylvain

 

[Jonathan Parminter]

-----Original Message-----
I do replace operation in an Excel sheet via Access. When string doesn'y
exist, I got a Warning. I want to disable it (not receiving it). There is a
way ?

I tried to do a find first, but find don't look in first cell of the
sheet... any ideas ?
sylvain

Hi Sylvain,

try

dim xlApp as excel.application

set xlApp = new excel.application
xlApp.displayalerts = false

p.s. you may be more successful posting questions
regarding excel to the excel usergroup.

Luck
Jonathan