How to hide msgbox duing automating excel..

[prakashsakthivel]

Hi Members

How to hide or prevent Excel runtime msgbox
while save the file.

Actually what i need is.
let's example
there is book1.xlz in xx folder..

Again I try to modify content thorough vb,
then it i check
xl.activeworkbo ok.close true
xl.activeworkbo ok.save

default Msg box will be opened. like already file exists in this location..

I want to hide or prevent


reagrds

Prakash.s

[QVeen72]

Hi,

Before Save Command give this :

[code=vb]
xlApp.DisplayAl erts = False
[/code]

REgards
Veena