Disabling Excel warning from VBA

  • Thread starter Thread starter Sylvain Provencher
  • Start date Start date
S

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
 
sylvain said:
-----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
Click to expand...

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
 
Back
Top